Column 'start_date' in where clause is ambiguous/* fetch generic dc list */ SELECT 
								DISTINCT
								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
								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 `marvel_content`.`graphic_usage` gu ON gu.content_id = st.story_id AND gu.content_type = 'comic_story'
								LEFT JOIN `marvel_content`.`graphic` g ON g.graphic_id = gu.graphic_id
								JOIN `marvel`.`dotcomics_issues` dc ON dc.catalog_id = i.issue_id
								 JOIN marvel_content.content_publication_zones cpz0 ON cpz0.content_id = dc.dotcomics_issue_id AND cpz0.content_type = 'digitalcomic'
 JOIN marvel_content.publication_zones pz0 ON pz0.id = cpz0.publication_zone_id AND pz0.name = 'marvel_site_zone'
								 JOIN marvel_content.content_publication_zones cpz1 ON cpz1.content_id = i.issue_id AND cpz1.content_type = 'comic_issue'
 JOIN marvel_content.publication_zones pz1 ON pz1.id = cpz1.publication_zone_id AND pz1.name = 'marvel_site_zone'	
								 JOIN marvel_content.content_publication_zones cpz2 ON cpz2.content_id = s.series_id AND cpz2.content_type = 'comic_series'
 JOIN marvel_content.publication_zones pz2 ON pz2.id = cpz2.publication_zone_id AND pz2.name = 'marvel_site_zone'
							WHERE 
								start_date BETWEEN DATE_SUB(CURDATE(),INTERVAL 2 WEEK) AND CURDATE() AND dc.qa_by <> 0 AND cpz0.active = 1 AND '2010-03-12 09:21:37' BETWEEN cpz0.start_date AND cpz0.end_date AND cpz1.active = 1 AND '2010-03-12 09:21:37' BETWEEN cpz1.start_date AND cpz1.end_date AND cpz2.active = 1 AND '2010-03-12 09:21:37' BETWEEN cpz2.start_date AND cpz2.end_date
								ORDER BY i.Series_name, syear, i.Issue_number