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 (1332,3624,7354,7969,8537,9968,10341,10358,10549,11435,11703,11711,12108,12179,12779,12840,12885,13411,13509,13578,13614,13664,13742,13770,13809,13811,13822,13914,14054,14393,14394,14523,14800,14991,15003,15159,15173,15239,15325,15356,15360,15495,15526,15534,15563,15634,15642,15677,15690,15742,15814,16044,16086,16087,16109,16199,16349,16611,16689,16747,16772,16914,17027,17044,17115,17247,17566,17778,17794,17938,17959,18101,18327,18340,18591,18605,18718,19070,19077,19282) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'