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