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 (6721,7441,12775,12865,13037,13167,13492,13597,13612,13619,13620,13669,13742,14140,14752,15164,15412,15451,15517,15642,15666,15822,15853,15859,15874,15925,15995,16036,16073,16356,16366,16433,16815,17104,17138,17221,17362,17725,17726,18280,18343,18551,18569,18702,18727,18872,19077,19087) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'