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 (1174,1296,1378,1404,2033,3497,6722,9541,9542,9543,9544,9545,9558,12978,12981,13024,13064,13140,13177,13197,13199,13205,13288,13354,13457,13518,13519,13528,13555,13556,13572,13619,13620,13656,13667,13726,13776,13824,13846,13863,13864,13881,13902,13920,13935,13939,13946,13978,13987,13989,13990,14000,14005,14011,14015,14153,14158,14162,14377,14391,14396,14419,14467,14528,14547,14576,14615,14666,14668,14705,14739,14740,14750,14775,14776,14794,14800,14833,14838,14860,14886,14970,14993,15024,15045,15046,15053,15063,15075,15092,15176,15212,15285,15288,15291,15325,15345,15354,15407,15417,15477,15529,15535,15560,15598,15631,15665,15738,15793,15802,15813,15815,15817,15819,15864,15870,15915,15926,15941,16002,16008,16026,16033,16038,16055,16070,16088,16102,16106,16153,16163,16173,16176,16182,16183,16208,16249,16250,16272,16292,16310,16321,16347,16352,16397,16400,16416,16436,16464,16481,16497,16547,16611,16681,16686,16725,16757,16759,16765,16771,16814,16817,16925,16975,16990,17015,17020,17047,17048,17060,17077,17084,17202,17230,17261,17281,17307,17339,17360,17361,17413,17424,17435,17436,17457,17478,17487,17520,17528,17542,17562,17612,17616,17621,17636,17637,17680,17699,17729,17736,17755,17757,17789,17796,17798,17829,17878,17882,17891,17901,17929,17958,17961,17991,17996,18119,18124,18171,18190,18232,18270,18274,18316,18364,18402,18439,18455,18460,18520,18573,18605,18625,18652,18655,18685,18686,18710,18740,18756,18807,18808,18819,18839,18875,18878) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'