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 (1420,1759,1761,1763,1849,3367,3442,7867,8475,8476,8477,8478,8835,8965,9336,9564,9652,9891,9926,10176,10179,10180,10181,10238,10428,10698,11703,11992,12046,12169,12641,12747,12798,13024,13199,13500,13726,13766,13810,14044,14159,14182,14183,14279,14649,14736,14973,15027,15092,15122,15182,15231,15280,15519,15596,15792,15817,15912,15998,16048,16051,16073,16123,16154,16187,16452,16463,16464,16468,16786,16797,16824,16878,17118,17131,17248,17287,17315,17340,17352,17360,17419,17794,17829,17858,17914,17996,18232,18240,18307,18369,18485) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'