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 (1771,2690,4491,5886,7808,8551,8846,9031,9060,9158,9938,10351,11097,11192,12519,12592,12961,13282,13431,13989,14053,14671,15093,15098,15645,15691,16284,16513,16520,16710,16715,16877,16981,17235,17254,17893,18015,18345,18394,18575,18837) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'