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 (2026,2039,7966,10011,10734,11165,13027,13514,13853,13855,13919,14259,14695,15094,15424,15492,15597,15796,15823,15954,16583,17094,17582,17929,17945,18038) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'