Query Run
select substring_index(page_title,'/',1), sum(page_len) as totlen from... 1 year ago
select substring_count(page_title,'/', -1), sum(page_len) as... 1 year ago
select substring(page_title,1,charindex('/', page_title)), ... 1 year ago
select substring(page_title,1,charindex('/', page_title)), ... 1 year ago
select substring(page_title,1,charindex('/', page_title)), ... 1 year ago
select page_title, page_len from page where page_namespace=1 order by... 1 year ago