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 (1167,1314,1316,1318,1319,1403,1769,1847,2614,3428,7890,8426,8428,8430,8580,9100,9101,9973,10470,10472,10520,10521,10522,10914,12220,12266,12363,12439,12440,12456,12546,12558,12561,12754,13089,13090,13091,13092,13180,13408,13411,13413,13425,13482,13486,13568,13569,13570,13571,13582,13615,13628,13655,13668,13724,13863,13864,13865,13887,13896,13962,14143,14148,14155,14157,14396,14709,14804,14906,15128,15274,15275,15505,15521,15563,15593,15595,15653,15764,15765,15839,15840,15862,15955,15958,16044,16116,16265,16270,16409,16509,16741,16866,17048,17060,17202,17435,17485,17487,17554,17587,17637,17700,17736,17737,17885,17891,18069,18079,18086,18097,18110,18435,18443,18463,18627,18628,18721,18782,18807,18808,18821) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'