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 (1769,4188,4285,6703,6704,6707,6713,6716,6717,6798,7909,7951,8228,8439,8488,8510,8532,8580,8958,9039,9150,9247,9271,9439,10248,10311,10312,10358,10600,10642,10807,10829,11111,11168,11234,11402,11424,11708,11889,11982,11987,12254,12404,12426,12427,12449,12450,12484,12498,12547,12769,12888,13448,13452,13466,13467,13472,13550,13713,13896,14044,14143,14412,14464,14694,14925,15128,15462,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,18097,18099,18215,18363,18721) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'