The Crimson Dynamo was a member of the Alpha Gen Soviet Super Soldiers and was put into a Cryogenic stasis where it would remain until it was awakened after a nuclear explosion was detected. After the Cold War ended the base it was positioned at became abandoned leaving him and his comrades. During a fight, the Order's member Infernal Man, set off an enormous explosion which was detected to be a nuclear blast activating the Crimson Dynamo and the rest of the Soviet Super Soldiers. They confronted the Order on their way to California where they were to wreak havoc. The Order found them to be nuclear and sought to find their base of operations. On Drenkov Island, Calamity found the three men controlling the Soviet Super Soldiers. Unable to kill the three sleeping men, due to moral values, Supernaut was sent to finish them off. Aralune sensing they only had one chance left ate the bomb and absorbed the blast. The blast apparently destroyed the Crimson Dynamo.
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 15:47:47' BETWEEN cpz1.start_date AND cpz1.end_date
AND chr.character_id =