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,2590,2616,3397,7478,9158,9457,9567,10760,11009,11045,11132,11266,12983,13128,13434,13581,13592,13619,13620,13742,14411,14714,14727,14963,15087,15120,15125,15136,15141,15344,15361,15723,15950,16024,16070,16379,16436,16532,16678,16882,16893,16898,16999,17023,17239,17280,17329,17660,17931,18057,18240,18703,18880,18983,19000,19100,19176,19215,19275) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'