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 (12683,13026,13272,13594,13714,13769,13783,13902,13915,15092,15148,15216,15217,15218,15280,15344,15406,15492,15510,15512,15515,15628,15651,15836,16038,16099,16140,16177,16281,16312,16378,16423,16449,16492,16676,17389,17394,17719,17843,17996,17997,17999,18075,18214,18377,18616,18667,18668,18672,18699,18742,18772,18812,18851,18903,18969,18970,19054,19059,19088,19196,19202,19263,19284) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'