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 (1293,1761,3474,6767,7353,8780,8808,9036,9546,10194,10798,11183,11422,11902,12080,12369,12409,12776,12879,12897,13004,13339,13347,13414,13427,13431,13513,13537,13635,13671,13743,14414,14468,14602,14682,14770,15162,15199,15412,15442,15470,15556,15684,15768,16050,16057,16146,16148,16210,16464,16587,16624,16867,17061,17311,17372,17430,17443,17492,17701,17803,17842,17896,17988,18078,18320,18328,18334,18454,18485,18588,18850) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'