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 (1307,1387,1421,3622,4406,5900,8334,8751,9117,9248,10595,10668,10857,11711,11955,12070,12173,12897,13018,13133,13636,13640,14106,14863,15036,15115,15332,15419,15423,15444,15624,15625,15679,15962,16964,17269,17355,17356,17357,17358,17359,17428,17555,17571,17572,17776,17943,18318,18454,18483,18674,18795,18823,18824,18825,18826,18827,18858,19194) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'