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 (778,1774,2734,3630,4620,11134,13180,13329,13338,13524,13672,13687,13753,14087,14406,14690,14849,15511,15533,16339,16345,16407,16414,16531,16619,16635,16685,17728,18115,18166,18303,18439,18456,18463,18728,18943) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'