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 (1194,1784,2614,3406,3473,9396,9896,10082,10254,10394,10798,12094,13116,13119,13164,13201,13305,13341,13349,13351,13416,13436,13531,13537,13621,13622,13756,13843,14711,14964,15222,15353,15367,15385,15461,15511,15653,15867,16048,16163,16184,16223,16295,16464,16575,16768,16923,17009,17105,17112,17408,17432,17790,17822,18236,18689,18699,18768,18871) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'