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 (1214,1264,1363,1415,1846,4188,6799,9084,9270,10076,10914,12451,12489,13319,13414,13450,13451,13452,13457,13467,13469,13470,13642,13678,13679,13680,13896,13936,13946,14151,14780,14895,14907,14925,14935,14993,15145,15261,15268,15269,15270,15271,15276,15297,15304,15417,15462,15470,15603,15668,15813,15865,16377,16380,16434,16703,16795,16799,17466,17473,18122,18268,18312,18322,18329,18686,18850) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'