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 (1166,1385,3389,3390,4399,8331,8456,8505,8531,8545,8546,9065,9801,10005,10104,10360,10387,10559,10690,10850,11181,11193,12456,12469,12470,12471,12472,12561,12718,12810,12892,13024,13089,13090,13091,13092,13130,13216,13284,13429,13535,13599,13667,13778,13809,13909,13910,13950,14020,14148,14443,14526,14704,14709,14736,14899,14906,14915,14947,14960,15027,15033,15074,15182,15216,15217,15218,15280,15354,15566,15683,15795,15812,15925,15930,15931,15935,15975,15978,16026,16058,16106,16263,16450,16513,16611,16716,16744,16764,16890,16920,17017,17030,17196,17209,17255,17261,17285,17291,17345,17364,17380,17406,17437,17470,17610,17641,17653,17660,17717,17793,17936,18120,18294,18629,18651,18727,18735,18790,18838) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'