Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT UPPER(wmf_last_access) AS last_seen_date,
- (unix_timestamp(CONCAT(year,'-',LPAD(month,2,'0'),'-',LPAD(day,2,'0')), 'yyyy-MM-dd') - 1483228800)/86400 AS days_till_next_access,
- SUM(view_count) AS frequency
- FROM zareen.webrequest_extract
- WHERE wmf_last_access IS NOT NULL
- AND UPPER(wmf_last_access) = '2017-JAN-01'
- AND year = 2017
- AND month = 1
- AND day < 9
- AND unix_timestamp(CONCAT(year,'-',LPAD(month,2,'0'),'-',LPAD(day,2,'0')), 'yyyy-MM-dd') >= 1483315200
- GROUP BY UPPER(wmf_last_access)
- ORDER BY last_seen_date, days_till_next_access LIMIT 1000;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement