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 (1197,1242,1770,1826,2593,3444,3452,4625,7467,7849,9313,9382,9950,11546,12163,12344,12345,13094,13190,13478,13503,13901,14088,14281,14669,14982,15414,15566,15684,15956,15991,16085,16209,16328,16513,16599,16705,17024,17232,17255,17287,17307,17364,17403,17474,17480,17725,17829,17880,18076,18294,18522,18575,18717,18818,18837,18882) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'