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,3473,3474,3816,6776,7950,8584,8731,8732,8792,8923,9048,9342,9459,9679,9698,10235,10238,10259,10287,10317,10394,10691,10727,10874,10974,11003,11183,11525,11591,11943,11997,12205,12344,12345,12509,12762,12897,13012,13147,13183,13418,13512,13537,13538,13539,14044,14156,14281,14429,14468,14606,14713,14865,14866,14961,14994,15067,15203,15278,15320,15459,15470,15515,15567,15928,15956,16033,16187,16210,16224,16290,16391,16452,16562,16585,16608,16761,16855,16982,17007,17012,17024,17033,17161,17257,17266,17311,17387,17641,17725,17740,17842,17857,17860,17922,17923,18011,18012,18572) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'