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 (4408,6768,7510,7821,7991,8413,8667,8856,8904,8982,9107,9109,9163,9244,9269,9317,9479,9734,9741,9810,9916,10011,10465,10502,10530,11249,11510,11750,11895,11980,12356,12388,12991,13193,13402,13413,13753,14051,14192,14193,14229,14325,14472,14614,14927,14945,14955,15068,15209,15581,15622,15629,15732,15783,15871,15880,16000,16001,16043,16073,16078,16091,16102,16117,16200,16254,16281,16319,16388,16470,16505,16803,17036,17193,17330,17590,17677,17709,17888,17908,18182,18187,18270,18273,18520,18547,18585,18608,18762,18809,18865,18881,19201) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'