SELECT
DISTINCT
af.a_ftv_market market,
af.a_ftv_channel channel,
ac.a_champion_season season,
ac.a_champion_round ROUND,
ac.a_champion_match "match",
ac.a_champion_quarter_1_start match_started_at,
af.a_ftv_episode_start episode_started_at,
af.a_ftv_episode_home_team home_team,
af.a_ftv_episode_away_team away_team,
af.a_ftv_episode_capture_time - (af.a_ftv_episode_start - ac.a_champion_quarter_1_start) ratings_captured_at,
ac.a_champion_score_time score_captured_at,
ac.a_champion_stadium played_at,
ac.a_champion_attendance number_in_attendance,
ac.a_champion_home_points home_score_this_minute,
ac.a_champion_away_points away_score_this_minute
FROM
a_ftv af LEFT OUTER JOIN a_champion ac
ON to_char(af.a_ftv_episode_start, 'yyyy-mm-dd') = to_char(ac.a_champion_quarter_1_start, 'yyyy-mm-dd')
AND af.a_ftv_episode_home_team = ac.a_champion_home_team
AND af.a_ftv_episode_away_team = ac.a_champion_away_team
AND af.a_ftv_episode_capture_time - (af.a_ftv_episode_start - ac.a_champion_quarter_1_start) = ac.a_champion_score_time
WHERE ac.a_champion_season = 2009
AND ac.a_champion_round = 2
ORDER BY
market,
season,
ROUND,
"match",
match_started_at,
episode_started_at