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 (1402,2034,3462,8620,9328,11569,12448,12507,12607,13113,13776,13896,13903,14486,14604,14790,14895,14925,14930,14932,14933,14935,14997,15042,15172,15571,16126,16161,16166,16247,16305,16511,16828,16995,17048,17088,17148,17168,17211,17351,17367,17385,17392,17478,17486,17494,17705,17714,17901,18052,18065,18129,18281,18323,18488,18683,18786,18850) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'