Query Run
WITH fac AS ( SELECT SUBSTR(rev_timestamp,1,4) AS year, page_title,... 12 months ago