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 (2604,2607,3816,6200,6760,7936,9348,9458,9871,10015,10095,11891,13498,13597,13997,14409,14587,15264,15619,15947,16448,17195,17853,17951,17952,18019,18070,18189,18332,18712) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'