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 (1416,2032,2584,2585,3463,3464,3494,12950,13122,13234,13639,13654,13670,13699,13747,13825,13928,13945,14036,14188,15044,15147,15251,15333,15821,15980,16051,16631,16632,16633,16634,16635,16819,17005,17282,17294,17388,17859,18215,18280,18311,18366,18394,18638,18677,18678,18863) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'