Błąd zapytania.
Query:
SELECT DISTINCT tvshow.* , rating.rating, rating.votes FROM files JOIN episode USING (idFile) JOIN tvshow USING (idShow) LEFT JOIN rating ON tvshow.c04=rating_id WHERE idMovie IN (2028,2035,2036,3493,9829,10019,10344,11516,11548,11559,13095,13197,13201,13431,13903,14393,14770,14867,14896,14897,15461,15779,15867,15982,16777,16828,16843,16881,16887,16900,17096,17295,17309,17315,17345,17395,17409,17558,17628,17880,17920,17936,17949,17999,18064,18077,18078,18246,18485) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'