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 (1264,1285,1840,2617,3396,6757,7487,8644,9456,9511,9758,9950,9953,10235,10263,10438,10584,10603,10953,11124,11609,12642,12869,13172,13355,13846,13935,14233,14391,14397,14761,14817,14923,14981,15285,15354,15515,15532,15598,15681,15742,15770,15793,16052,16297,16302,16492,16495,16516,16815,17078,17156,17200,17342,17413,18205,18342,18408,18565,18717,19025,19156,19205,19206,19239,19248,19249,19260,19280) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'