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 (1378,1843,2617,6424,8692,8695,9885,9970,11280,12338,13597,13619,13620,13624,13715,13727,13997,14013,14634,14800,14802,14928,14976,15120,15401,15506,15549,15659,15706,15866,15922,15999,16099,16254,16262,16268,17049,17138,17501,17592,17670,17917,18130,18390,18605,18656,18791,18877) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'