Query Run
select count(distinct(page_id)) as c, page_id, page_title, ... 1 year ago