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 (1758,3366,3473,8415,8459,8552,12302,13164,13472,13484,13531,13622,13696,13996,14145,14465,14478,14605,14767,15010,15120,15203,15400,15511,15514,15528,15533,15567,15667,15765,16104,16575,16621,16740,16819,17009,17212,17445,18104,18106,18291,18495,18699,18899,18940,18943,19041,19219,19233,19313,19390,19393,19419,19509,19560) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'