Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (
- SELECT
- LO_ENTRY_ID,
- DATE(derived_tstamp) interval_date, --
- LO_ENTRY_NAME, --
- calendar_order, --
- lo_visible_on_homescreen, --
- lo_entry_min_trophies min0, --
- lo_entry_max_trophies max0, --
- lo_entry_tickets_required, --
- null lo_entry_trophy_mode,
- null lo_entry_trophy_gain,
- null lo_entry_trophy_loss,
- FROM
- (SELECT * FROM (SELECT *,CASE WHEN lo_entry_ts IS NULL THEN lo_entry_update_ts ELSE lo_entry_ts END lo_entry_ts2,ROW_NUMBER() OVER (partition BY lo_entry_id ORDER BY lo_entry_ts2 DESC) rn FROM CANDIVORE.PROD.F_LIVEOPS_CALENDAR) WHERE rn = 1)
- ) A ON A.calendar_entry_id = B.lo_entry_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
