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 (1367,8520,8521,8522,8523,8524,8525,8526,8527,8528,9308,9520,9723,10097,10726,11231,11232,12098,12099,12709,13240,13267,13488,13597,14794,14927,14945,14986,15682,15936,16213,16254,16946,17266,17638,18077,18524,18771,18823,18824,18825,18826,18827,18858,19326,19481,19574) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'