Query Run
select substring_index(tl_title, '/', 1) as root_page, count(*) as... 3 years ago
select substring_index(tl_title, '/', 1) as prefix, count(*) as... 3 years ago
select substring_index(tl_title, '/', 1) as prefix, count(*) as... 3 years ago