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 (128,2055,2557,3622,4411,7803,8539,8565,8837,8850,9852,10399,10430,10918,11289,11290,12021,12522,12905,12994,13395,13770,14066,14106,14130,14612,15115,15420,15426,15526,15628,15728,15933,16021,16419,16523,16669,16918,17276,17294,17555,17778,17802,17803,17804,17805,17806,17807,17808,17809,17956,17965,17992,18063,18102,18237,18337,18576,18618,19015,19048,19070,19086,19119,19219,19274) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'