Query Run
WITH r as ( SELECT rev_page, substring(rev_timestamp, 1, 8) date FROM... 1 year ago
WITH r as ( SELECT rev_page, substring(rev_timestamp, 1, 8) date FROM... 1 year ago
WITH r as ( SELECT rev_page, substring(rev_timestamp, 1, 8) date FROM... 1 year ago
SELECT count(distinct(rev_page))#rev_page, substring(rev_timestamp, 1, 8)... 1 year ago
SELECT count(distinct(rev_page))#rev_page, substring(rev_timestamp, 1, 8)... 1 year ago
SELECT count(distinct(rev_page))#rev_page, substring(rev_timestamp, 1, 8)... 1 year ago
SELECT count(distinct(rev_page))#rev_page, substring(rev_timestamp, 1, 8)... 1 year ago
SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... 1 year ago