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 (1134,1174,1802,5401,5420,6179,8408,8468,8469,8470,8472,8891,9524,11208,11444,12858,12974,13004,13005,13007,13008,13021,13089,13371,13400,13420,13456,13555,13573,13727,13741,14148,14650,14665,14709,14899,14906,15524,15614,15621,15677,15678,15698,15732,15738,15740,15749,15754,15786,15833,16027,16097,16173,16264,16297,16397,16404,16448,16723,16785,16889,16963,17018,17358,17985,18127,18211,18276,18486,18618,18626,18826) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'