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