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 (192,203,558,691,881,931,1014,1065,1127,1286,1308,1747,2120,2132,2471,2915,2927,3131,3353,3693,3707,3807,4168,4290,4393,4441,6744,7420,7451,7819,7964,8275,8367,8602,8664,8737,8741,8784,8799,8830,8881,8882,8924,8925,8926,8927,8948,8949,9114,9175,9298,9335,9363,9414,9422,9529,9565,9635,9661,9693,9726,9754,9898,9975,10140,10199,10210,10261,10307,10321,10346,10352,10446,10505,10613,10636,10652,10667,10672,10699,11030,11067,11112,11131,11163,11172,11263,11329,11335,11479,11594,11644,11678,11756,11784,11793,11809,11978,12014,12051,12053,12063,12079,12081,12170,12187,12214,12260,12277,12394,12428,12486,12487,12488,12536,12657,12674,12820,14187,14219,14220,14266,14289,14314,14376,14746,14999,15060,15081,15087,15121,15234,15290,15583,15681,15830,16053,16100,16393,16514,16577,16647,16672,16673,16683,16707,16712,16721,16750,16787,16788,16891,16916,16939,17271,17352,17372,17440,17458,17460,17471,17565,17681,17742,17782,17789,17862,17865,17895,17916,17937,17939,18099,18149,18154,18172,18228,18289,18350,18391,18422,18449,18550,18766,18809,18849,18881) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'