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 |