Mine

SELECT *
		from 
		action_american_football_play_participant 
		LEFT OUTER JOIN action_american_football_score  ON action_american_football_play_participant.play_id = action_american_football_score.id
		INNER JOIN events ON action_american_football_score.event_id = events.event_id

		WHERE 
		action_american_football_play_participant.player_idref = 'l.nfl.com-p.287' 
		AND action_american_football_score.score_type = 'field-goal'
		AND action_american_football_score.Date_coverage_type =  (select top 1 action_american_football_score.date_coverage_type from action_american_football_score where action_american_football_score.date_coverage_value = events.event_key order by action_american_football_score.date_coverage_type) 
		AND  events.start_date_time_local BETWEEN '9/30/2007' AND '10/3/2007'