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 (3431,9637,9666,12327,12365,12960,13024,13072,13162,13382,13434,13533,13534,13555,13587,13916,13923,13936,13938,13950,14068,14309,14397,14440,14908,14928,15146,15206,15264,15280,15651,15683,15688,15978,16058,16676,16776,16950,17280,17393,17437,17542,17550,17556,17660,17722,18128,18237,18711,18841) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'