An Error Was Encountered

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'cannes-2007, 15' at line 1

SELECT `n`.*, `c`.`pcid`, `c`.`link` AS `clink`, `c`.`title` as `ctitle` FROM `hdm_categories` AS `c` LEFT JOIN `hdm_news` AS `n` ON `n`.`cid` = `c`.`cid` WHERE `active`='1' AND `c`.`link`='his-dark-materials-movies' AND `stamp` < '1219249100' ORDER BY `top` DESC, `stamp` DESC LIMIT cannes-2007, 15