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 (3463,3464,4336,10717,13261,13287,13387,13480,13623,13715,13823,13945,13987,14040,14134,14376,14381,14440,14465,14466,14655,14704,14767,14776,14802,14886,14893,14951,14986,15092,15136,15251,15293,15294,15352,15441,15446,15495,15497,15506,15571,15598,15607,15680,15748,15750,15759,15785,15788,15794,15842,15864,15870,15981,16002,16039,16073,16111,16217,16254,16288,16372,16456,16547,16581,16599,16892,16916,17171,17430,17477,17591,17623,17711,17714,17931,17997,18057,18061,18073,18125,18398,18616,18726,18742,18744,18810,18850,18866) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'