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 (1840,6715,7469,9808,9864,10113,11617,12552,12869,13012,13444,13483,13521,13624,13796,13914,13915,14013,14078,14143,14307,14395,14650,14698,14705,14735,14848,14923,14927,15033,15129,15159,15252,15355,15600,15610,15801,15868,15938,16021,16305,16366,16449,16700,17005,17212,17318,17326,17330,17380,17486,17635,17657,17949,17996,18579,18599,18718,18721,18755,18810,18874,18882) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'