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 (8509,12426,12427,13498,13814,13909,13910,14228,14231,14480,14481,14482,14483,14948,15028,15200,15696,15822,16140,16213,16785,16871,16998,17079,17091,17276,17291,17358,17361,17373,17388,17446,17585,17818,18294,18636,18702,18826) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'