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;