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 (1371,1788,1851,4520,5893,6798,7847,7867,8412,8554,9789,10228,11044,11069,11235,11310,11383,11435,11463,11497,11573,12925,13144,13147,13272,13284,13444,13514,13562,13624,13673,13715,13915,13932,14059,14156,14255,14535,14617,14634,14988,15002,15094,15119,15129,15363,15404,15414,15436,15467,15517,15597,15600,15836,15995,16124,16129,16154,16162,16187,16214,16262,16291,16400,16423,16503,16568,16733,16824,16879,16989,17027,17099,17138,17220,17230,17531,17628,17782,17795,17974,18078,18127,18269,18325,18341,18353,18390,18556,18668) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'