Wiki User Tools: Help

draft source

Marvel Universe 

Revision history of "Wild Pack"

Revision history of "Wild Pack"

(Latest | Earliest) View (newer 50) (older 50) (20 | 50 | 100 | 250 | 500)

Diff selection: mark the radio boxes of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with current revision, (prev) = difference with preceding revision, m = minor edit.

(Latest | Earliest) View (newer 50) (older 50) (20 | 50 | 100 | 250 | 500)

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 '2014-08-23 04:13:56' BETWEEN cpz1.start_date AND cpz1.end_date AND chr.character_id =