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,1196,1404,1587,1770,3367,3452,6761,6762,7345,7457,7460,7804,7876,7921,7959,8326,8409,8411,8579,8655,8967,8996,9122,9418,9487,9642,9824,9943,10006,10168,10294,10295,10296,10324,10335,10445,10475,10587,10633,10700,10739,10813,10876,10947,10975,10982,11003,11028,11189,11302,11374,11414,11686,11959,12065,12090,12195,12426,12427,12561,12798,12891,12897,12960,13012,13015,13050,13151,13230,13344,13347,13442,13502,13625,13756,13776,13853,13910,13924,13960,14038,14181,14309,14371,14477,14694,14732,14741,14908,14924,14930,14932,14933,14948,14964,14973,14990,15005,15053,15496,15597,15669,15737,15867,15925,15961,15975,15986,16024,16026,16082,16124,16154,16173,16430,16513,16607,16640,16684,16764,16776,16890,16920,16981,17100,17147,17206,17262,17287,17315,17349,17361,17373,17374,17422,17442,17469,17504,17530,17582,17585,17658,17682,17696,17734,17829,17857,17893,18188,18213,18293,18314,18315,18355,18364,18370,18482,18565,18727,18750,18837,18905,18909,18936,18978,19022,19026,19043,19137,19206,19266,19291) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'