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 (1824,2584,3442,3816,4729,9122,10357,10708,10776,11404,11434,11620,12174,12425,12885,12886,12962,12994,13023,13234,13352,13442,13471,13498,13519,13687,13699,13760,13928,14254,14407,14583,14814,15259,15418,15547,15554,15725,15726,15755,15801,15972,16048,16049,16050,16051,16056,16151,16334,16401,16554,16626,16631,16632,16633,16634,16635,16661,16955,16956,17005,17040,17121,17240,17248,17322,17340,17450,17479,17627,17632,17899,18187,18188,18209,18308,18338,18486,18487,18677,18678) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'