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 (1375,1762,2616,3402,3434,3481,7961,8459,8556,8754,9053,9699,10181,10250,10440,10726,10814,10829,10990,11011,11139,11245,11411,12366,12369,12484,12683,12747,12887,13308,13465,13810,14159,14182,14183,14399,14401,14402,15499,15525,15626,15871,16049,16052,16469,16867,17009,17052,17310,17870,17997,18570) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'