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 (1329,1373,1421,1789,2584,2585,2614,3406,4714,6198,7977,8228,8532,10254,10464,12426,12427,12449,12450,12483,13082,13136,13201,13352,13363,13416,13436,13444,13464,13478,13519,13531,13537,13618,13636,13637,13756,13760,13819,13843,13958,14038,14042,14061,14149,14188,14288,14583,14711,14766,14803,14865,14866,14867,14886,14902,14948,14964,14996,15112,15203,15332,15353,15366,15367,15424,15435,15443,15461,15493,15538,15539,15561,15567,15653,15654,15761,15867,15869,15876,15969,15982,16016,16025,16050,16051,16057,16089,16090,16133,16147,16151,16250,16251,16270,16278,16294,16301,16305,16314,16319,16343,16345,16437,16443,16581,16631,16632,16633,16634,16635,16649,16670,16680,16923,16946,17017,17038,17040,17061,17097,17213,17311,17319,17371,17375,17432,17485,17486,17526,17536,17585,17603,17620,17661,17668,17714,17726,17765,17770,17776,17790,17793,17943,17989,18074,18078,18348,18356,18366,18474,18521,18578,18652,18668,18677,18678,18699,18755,18768,18859,18860,18871) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'