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 (13117,13119,13144,13165,13267,13272,13308,13552,13579,13596,13640,13803,13817,13824,13919,13927,13946,13954,14055,14058,14065,14087,14423,14514,14574,14605,14727,14794,14846,14931,14963,15077,15087,15148,15309,15398,15521,15570,15605,15650,15763,15837,15912,16002,16070,16099,16128,16177,16254,16344,16377,16467,16533,16538,16617,16644,16814,16818,16886,16960,16984,17023,17154,17413,17426,17497,17589,17619,17669,17687,17870,17917,17990,18085,18346,18475,18569,18582,18642,18691,18785,18793,18810,18818,18879) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'