Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement