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 (1330,1587,1802,6423,8325,9004,10153,11945,13165,13508,13532,13589,13613,13909,13910,13915,13954,14556,14899,15200,15241,15413,15419,15479,16016,16182,16186,16338,16533,16624,16626,16822,16990,17169,17173,17413,17539,17778,18078,18589,18703,18880) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'