SELECT `p`.`person_key`,  `e`.`event_key`,
	`e`.`event_status`,
	`bps`.`strikeouts`,
	`bps`.`innings_pitched`,
	`bps`.`wins`,
	`bps`.`hits`,
	`bps`.`balks`,
	`bps`.`earned_runs`
FROM `persons` AS `p`
 INNER JOIN `person_event_metadata` AS `pem` ON pem.person_id = p.id
 INNER JOIN `events` AS `e` ON pem.event_id = e.id
 INNER JOIN `affiliations_events` AS `ae` ON ae.event_id = e.id
 INNER JOIN `affiliations` AS `a` ON a.id = ae.affiliation_id
 INNER JOIN `stats` AS `s` ON s.stat_coverage_id = e.id AND s.stat_holder_id = p.id
 INNER JOIN `baseball_pitching_stats` AS `bps` ON s.stat_repository_id = bps.id
WHERE
	(e.event_status = 'post-event')
	AND (a.affiliation_key = 'l.mlb.com')
	AND (a.publisher_id = '1')
	AND (s.stat_repository_type = 'baseball_pitching_stats')
	AND (s.stat_coverage_type = 'events')
	AND (s.stat_holder_type = 'persons')
	AND (s.context = 'event')
	AND (e.start_date_time > '2008-04-11 00:00:00')
	AND (e.start_date_time <= '2008-04-11 23:59:59')
	AND (p.person_key = 'l.mlb.com-p.13453')