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 |