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 (1808,4622,6698,7448,8366,9036,9146,9532,9667,9881,10464,10912,11189,11887,11987,12391,13198,13442,13514,13517,13666,14395,14753,15006,15358,15931,16168,16447,16464,16605,16632,16855,16987,17047,17209,17379,17461,17513,17586,17763,17887,17904,17984,18014,18052,18065,18378,18480,18873,18883,18972,19178,19236,19345,19408,19573) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'