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 (1277,1330,1370,1371,1375,1381,1420,1770,1771,1798,1802,1811,1826,2604,2607,2647,3367,3431,3460,3480,3481,3622,4525,4530,6201,6205,6378,6692,7417,7424,7429,7443,7453,7483,7506,7512,7834,7905,7971,8226,8237,8248,8254,8280,8282,8359,8468,8469,8470,8472,8549,8589,8593,8595,8600,8692,8714,8715,8716,8717,8730,8782,8908,8951,8979,8997,9023,9065,9213,9240,9295,9306,9336,9399,9418,9458,9459,9477,9478,9511,9678,9820,9893,9905,9920,9926,9943,9948,9982,9990,10152,10160,10176,10179,10180,10181,10228,10281,10323,10324,10344,10410,10414,10476,10498,10564,10589,10590,10599,10690,10722,10781,10803,10811,10857,10920,10949,10952,10960,11012,11023,11066,11069,11095,11136,11216,11264,11361,11372,11374,11444,11459,11463,11500,11533,11549,11554,11567,11588,11692,11694,11704,11712,11785,11804,11959,12036,12049,12058,12136,12145,12160,12243,12366,12369,12388,12411,12554,12601,12727,12747,12766,12810,12812,12870,12881,12882,12883,12887,12891,12898,12909,12925,12931,12938,12960,12972,12986,12987,12990,13004,13005,13007,13008,13010,13012,13014,13015,13021,13029,13126,13130,13153,13157,13161,13190,13199,13228,13284,13288,13298,13382,13403,13420,13438,13450,13456,13467,13494,13511,13512,13513,13533,13555,13580,13584,13587,13589,13595,13661,13680,13682,13707,13727,13731,13733,13756,13761,13766,13770,13777,13789,13806,13810,13821,13843,13846,13847,13850,13874,13909,13910,13916,13919,13923,13924,13929,13932,13935,13960,13963,13984,14028,14068,14085,14142,14149,14157,14159,14170,14182,14183,14233,14256,14268,14272,14290,14296,14309,14316,14317,14318,14413,14414,14415,14426,14502,14526,14533,14547,14582,14586,14590,14647,14663,14670,14711,14721,14722,14737,14770,14795,14803,14848,14862,14902,14908,14919,14947,14981,14988,14990,14991,14997,15011,15033,15086,15093,15094,15123,15127,15146,15173,15187,15189,15200,15206,15223,15237,15262,15280,15293,15294,15295,15396,15403,15404,15406,15428,15439,15441,15442,15444,15459,15479,15499,15511,15512,15520,15521,15525,15526,15552,15596,15597,15599,15607,15610,15624,15626,15631,15645,15651,15665,15683,15688,15690,15747,15794,15812,15817,15834,15844,15870,15871,15877,15897,15908,15915,15925,15930,15961,15967,15984,15986,15997,15998,15999,16001,16021,16024,16026,16030,16039,16049,16073,16086,16091,16114,16124,16162,16186,16187,16200,16211,16221,16225,16241,16244,16251,16261,16312,16316,16323,16396,16404,16416,16417,16421,16443,16452,16463,16464,16470,16476,16485,16513,16516,16525,16541,16585,16600,16603,16623,16645,16690,16705,16711,16716,16718,16733,16764,16774,16776,16777,16785,16790,16806,16838,16840,16856,16863,16878,16883,16904,16907,16913,16914,16941,16942,16943,16944,16953,16963,16981,16988,16989,16997,17001,17009,17024,17037,17076,17078,17091,17094,17100,17119,17121,17139,17147,17180,17193,17195,17208,17245,17254,17255,17262,17265,17268,17278,17285,17287,17300,17308,17310,17315,17336,17357,17367,17374,17419,17422,17432,17436,17478,17489,17490,17530,17537,17539,17542,17579,17580,17616,17636,17641,17647,17658,17662,17682,17709,17716,17719,17722,17725,17794,17795,17798,17799,17800,17811,17819,17822,17850,17853,17867,17873,17880,17901,17919,17929,17936,17968,17972,17974,17985,17996,18015,18019,18064,18085,18120,18128,18133,18153,18173,18203,18213,18214,18233,18247,18248,18266,18269,18270,18271,18313,18324,18325,18332,18335,18341,18353,18370,18377,18398,18411,18431,18448,18454,18487,18493,18516,18517,18525,18526,18556,18581,18611,18620,18621,18660,18665,18697,18703,18714,18726,18727,18768,18787,18790,18794,18841,18858,18875,18880) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'