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 (4529,8574,11899,13050,13082,13436,13464,14061,14849,14865,14866,15203,15352,15400,15514,15652,15684,16308,16451,16531,16572,16573,17120,17661,17774,17897,18068,18104,18124,18162,18163,18291,18373,18374,18375,18376,18495,18496,18497,18498,18499,18697,18940) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'