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 (1205,1388,1847,2604,2607,3367,3389,3390,3397,3816,4548,4623,8223,8509,9193,9260,9436,9536,9603,10095,10253,10957,11416,11436,11638,11688,12080,13004,13094,13427,13523,13562,13580,13814,14011,14044,14134,14228,14231,14480,14481,14482,14483,14776,14793,14843,15028,15459,15768,16049,16060,16088,16123,16186,16235,16355,16420,16468,17150,17446,17598,17853,17892,17920,17941,18069,18119,18158,18332,18485,18682,18697,18710,18800) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'