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 (4285,6703,6704,6707,6713,6716,6717,7909,7951,8439,8488,8510,8580,8958,9039,9150,9247,9271,9439,10248,10358,10600,10642,10807,10829,11111,11168,11234,11402,11708,11889,11917,11982,11987,12248,12254,12262,12263,12404,12426,12427,12449,12450,12484,12498,12547,12706,12769,12888,13017,13448,13450,13451,13452,13454,13455,13457,13460,13461,13466,13467,13468,13469,13470,13472,13550,13555,13706,13713,13896,14044,14412,14464,14694,14925,15128,15145,15146,15462,15463,15465,15467,15470,15668,15757,15761,15862,15944,15955,15958,16089,16090,16250,16369,16371,16443,16760,16761,16859,16860,16864,16928,16999,17194,17811,17891,17989,18087,18097,18099,18215,18356,18363,18721,19202,19402,19408,19409,19504) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'