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 (1300,12877,12998,13052,13560,13576,13764,13792,13920,14050,14420,14484,14485,14551,14858,15158,15541,15644,15648,15684,15776,15979,16037,16066,16350,16470,16520,16551,16773,17026,17154,17390,17465,17556,17669,17722,17735,17817,17868,17872,17939,17959,18084,18176,18217,18220,18339,18363,18798) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'