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 (14662,14720,14820,14821,14932,15000,15536,15686,15802,15864,15868,15976,16058,16118,16299,16484,16593,16648,16685,16729,16746,16760,16839,16946,17164,17287,17449,17728,17746,17765,17774,17950,18068,18100,18141,18177,18211,18287,18343,18487) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'