Lost connection to MySQL server during query/* fetch generic dc list */ (SELECT 
								s.series_id,
								i.issue_id,
								s.series_name as sname,
								i.issue_number as inum,
								s.series_start_year as syear
							FROM `catalog`.`series` s
								LEFT JOIN `catalog`.`issues` i ON s.series_id = i.series_id
								LEFT JOIN `catalog`.`collections` col ON i.Issue_id = col.Issue_id
								LEFT JOIN `catalog`.`story` st ON col.story_id = st.story_id
								LEFT JOIN `marvel_content`.`character_relations` cr ON (cr.content_id = st.story_id AND cr.content_type = 'comic_story' AND cr.appearance_type IS NOT NULL )
								LEFT JOIN `marvel_content`.`characters` c ON c.character_id = cr.character_id 
								LEFT JOIN `catalog`.`creator_relations` cre_r ON st.story_id = cre_r.story_id
								LEFT JOIN `catalog`.`creators` cre ON cre.creator_id = cre_r.creator_id 
								LEFT JOIN `catalog`.`series_flags` sf ON sf.series_id = s.series_id
								LEFT JOIN `marvel_content`.`graphic_usage` gu ON gu.content_id = s.Series_id AND gu.content_type = 'comic_series'
								LEFT JOIN `marvel_content`.`graphic` g ON g.graphic_id = gu.graphic_id
								JOIN `marvel`.`dotcomics_issues` dc
								JOIN `marvel_content`.`content_relation` cont_r
								JOIN `marvel_content`.`display_junk` dj 
							WHERE 
								character_name = 'X-Force' AND dc.qa_by <> 0 AND active = 1 AND curdate() BETWEEN start_date AND end_date
								AND dc.catalog_id = i.issue_id
								AND cont_r.content_id = dc.dotcomics_issue_id
								AND cont_r.content_type = 'digitalcomic' 
								AND dj.display_id = cont_r.display_id
								ORDER BY i.Series_name, i.Issue_number
								) UNION /* fetch generic dc list */ (SELECT 
								s.series_id,
								i.issue_id,
								s.series_name as sname,
								i.issue_number as inum,
								s.series_start_year as syear
							FROM `catalog`.`series` s
								LEFT JOIN `catalog`.`issues` i ON s.series_id = i.series_id
								LEFT JOIN `catalog`.`collections` col ON i.Issue_id = col.Issue_id
								LEFT JOIN `catalog`.`story` st ON col.story_id = st.story_id
								LEFT JOIN `marvel_content`.`character_relations` cr ON (cr.content_id = st.story_id AND cr.content_type = 'comic_story' AND cr.appearance_type IS NOT NULL )
								LEFT JOIN `marvel_content`.`characters` c ON c.character_id = cr.character_id 
								LEFT JOIN `catalog`.`creator_relations` cre_r ON st.story_id = cre_r.story_id
								LEFT JOIN `catalog`.`creators` cre ON cre.creator_id = cre_r.creator_id 
								LEFT JOIN `catalog`.`series_flags` sf ON sf.series_id = s.series_id
								LEFT JOIN `marvel_content`.`graphic_usage` gu ON gu.content_id = i.Issue_id AND gu.content_type = 'comic_issue'
								LEFT JOIN `marvel_content`.`graphic` g ON g.graphic_id = gu.graphic_id
								JOIN `marvel`.`dotcomics_issues` dc
								JOIN `marvel_content`.`content_relation` cont_r
								JOIN `marvel_content`.`display_junk` dj 
							WHERE 
								character_name = 'X-Force' AND dc.qa_by <> 0 AND active = 1 AND curdate() BETWEEN start_date AND end_date
								AND dc.catalog_id = i.issue_id
								AND cont_r.content_id = dc.dotcomics_issue_id
								AND cont_r.content_type = 'digitalcomic' 
								AND dj.display_id = cont_r.display_id
								ORDER BY i.Series_name, i.Issue_number
								) ORDER BY sname ASC, syear ASC, inum ASC