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 15SELECT distinct i.issue_id, dci.dotcomics_issue_id, if(cpz1.active = 1 AND CURDATE() BETWEEN cpz1.start_date AND cpz1.end_date,1,0) as dc_is_live FROM catalog.collections col JOIN marvel_content.character_relations chr ON chr.content_id = col.story_id AND chr.content_type = 'comic_story' JOIN catalog.issues i ON i.issue_id = col.issue_id LEFT join marvel.dotcomics_issues dci ON dci.catalog_id = i.issue_id AND dci.qa_by <> 0 JOIN marvel_content.content_relations cr ON cr.content_id = dci.dotcomics_issue_id AND cr.content_type = 'digitalcomic' JOIN marvel_content.content_publication_zones cpz1 ON cpz1.content_id = chr.content_id AND cpz1.content_type = chr.content_type JOIN marvel_content.publication_zones pz1 ON pz1.id = cpz1.publication_zone_id AND pz1.name = 'marvel_site_zone' WHERE cpz1.active = 1 AND '2012-05-31 23:04:23' BETWEEN cpz1.start_date AND cpz1.end_date AND chr.character_id =