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 '' at line 8 SELECT p.* FROM promotions p, promotions_map pm WHERE pm.contentId = p.ID AND pm.contentType='product' AND p.startDate <= NOW() AND p.expireDate > NOW() AND p.ID =