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 (1149,2035,3644,4505,8509,9278,10539,11069,11486,12887,12897,12972,13199,13380,13565,13581,13814,14228,14231,14373,14393,14482,14483,14579,14580,14581,14602,14736,15027,15028,15031,15051,15098,15182,15240,15363,15499,15525,15603,15943,16060,16169,16245,16444,16475,16495,16502,16530,16669,16774,16963,16981,17001,17009,17019,17037,17310,17326,17374,17484,17535,17636,17834,18078,18313,18325,18341,18448,18606,18618,18620,18644,18676,18701,18714,18811,18875,18997,19005,19077,19119,19268) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'