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 (1163,3367,3475,3481,4471,6423,6750,7450,7495,8228,8360,8468,8469,8470,8472,8532,8589,8684,8712,9002,9004,9092,9271,9289,9441,9481,9501,9692,9830,9921,10042,10159,10280,10299,10322,10323,10369,10377,10410,10487,10569,10673,10832,10960,10966,11066,11151,11182,11213,11214,11444,11454,11497,11583,11704,11726,11939,12347,12449,12450,12555,12836,12887,12891,12912,12931,13004,13005,13007,13008,13010,13014,13017,13126,13159,13396,13420,13438,13456,13494,13555,13561,13573,13595,13630,13634,13635,13661,13682,13706,13707,13708,13752,13766,13807,13812,13894,13911,13988,14068,14154,14159,14262,14283,14292,14298,14308,14346,14557,14579,14582,14621,14819,14862,14919,14949,15031,15035,15146,15200,15206,15223,15224,15258,15406,15428,15449,15450,15473,15478,15499,15512,15525,15536,15599,15618,15651,15676,15688,15698,15740,15758,15761,15834,15897,15944,16027,16030,16089,16090,16097,16241,16312,16382,16404,16442,16448,16729,16774,16955,16988,17009,17014,17016,17160,17161,17162,17163,17182,17222,17310,17335,17355,17356,17357,17358,17359,17382,17449,17481,17579,17593,17624,17867,17967,17985,17989,18133,18152,18203,18266,18276,18324,18325,18335,18358,18364,18384,18516,18517,18525,18526,18562,18596,18620,18621,18690,18694,18703,18823,18824,18825,18826,18827,18858,18880) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'