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 (10502,12608,12937,13177,13485,13650,13823,14013,14472,14736,14899,14945,15027,15092,15094,15182,15560,15679,16058,16599,16685,16764,16767,17298,17330,17333,17611,17700,17728,17906,18039,18137,18589,18636,18820) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'