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,1812,3368,4411,4606,8002,8321,8695,8714,8715,8716,8717,8928,8989,9477,9511,9948,10444,10589,10590,10803,11136,11435,11463,12382,13021,13074,13124,13306,13367,13390,13437,13445,13580,13594,13614,13673,13771,13899,14323,14401,14650,14750,14795,14928,15003,15403,15414,15468,15599,15614,15621,15645,15649,15660,15664,15674,15827,15908,15947,16048,16086,16099,16129,16173,16235,16302,16558,16772,16824,16833,16907,16913,16914,16927,16941,16942,16943,16944,16989,17025,17111,17270,17274,17336,17558,17802,17803,17804,17805,17806,17807,17808,17809,18058,18200,18211,18353,18491,18516,18517,18525,18526,18551,18620,18621,18673,18687,18851) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'