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 (14962,14973,15067,15271,15571,15603,15763,15773,15930,15931,16135,16161,16216,16434,16504,16703,16827,16828,17325,17443,17478,17554,17596,17698,17739,17858,17901,17951,17952,18070,18290,18320,18322,18585,18640,18686,18786,18889) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'