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 (1285,3366,3624,4406,4414,7441,7470,8714,8715,8716,8717,9585,10491,10589,10590,11229,11302,11406,11968,12532,12840,12865,13021,13355,13578,13792,13809,13822,14728,14822,14893,15249,15262,15360,15403,15479,15517,15634,15742,15952,15995,16086,16087,16219,16262,16297,16349,16376,16611,16747,16913,16914,16941,16942,16943,16944,16989,17115,17219,17221,17336,17470,17566,18197,18460,18551,19291) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'