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