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 (1358,1788,4408,4429,7803,8565,8980,9637,10520,10521,12468,12754,13147,13155,13193,13341,13379,13483,13607,13684,14147,14153,14156,14401,14439,14440,14464,14585,14820,14821,14895,14908,14923,14935,14973,15046,15067,15100,15215,16008,16138,16224,16309,16431,16639,16842,16898,16993,17069,17280,17324,17839,17950,18065,18097,18175,18233,18756,18878) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'