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 (1388,4188,6798,7809,7845,10036,10728,11649,11886,11934,12925,13029,13136,13432,13448,13452,13454,13457,13466,13467,13470,13472,13592,13922,14323,15141,15404,15462,15463,15467,15470,15624,16128,16356,16499,16507,16772,16786,16818,16833,16888,16977,17099,17402,17620,17899,17970,18100,18353) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'