Query Run
select substring_index( page_title, '/', if(instr(page_title,... 1 year ago
select substring_index( page_title, '/', if(instr(page_title,... 1 year ago
select substring_index( page_title, '/', if(instr(page_title,... 1 year ago
select substring_index( page_title, '/', if(instr(page_title,... 1 year ago
select substring_index( page_title, '/', if(instr(page_title,... 1 year ago
select if(instr(page_title, 'zh/') = 1, substring_index(page_title, '/', 3),... 1 year ago
select if(instr(page_title, 'zh/') = 1, substring_index(page_title, '/', 3),... 1 year ago
select if(instr(page_title, 'zh/') = 1, substring_index(page_title, '/', 3),... 1 year ago
select if(instr(page_title, 'zh/') = 1, substring_index(page_title, '/', 3),... 1 year ago
select if(instr(page_title, 'zh/') = 1, substring_index(page_title, '/', 3),... 1 year ago
select if(instr(page_title, 'zh') = 1, substring_index(page_title, '/', 3),... 1 year ago
select if(instr(page_title, 'zh') = 1, substring_index(page_title, '/', 3),... 1 year ago
select if(instr(page_title, 'zh') = 1, substring_index(page_title, '/', 3),... 1 year ago
select if(instr(page_title, 'zh') = 1, substring_index(page_title, '/', 2),... 1 year ago
select substring_index(page_title, '/', 1) as subpage, sum(page_len) as... 1 year ago
select page_namespace as namespace, substring_index(page_title, '/', 1) as... 1 year ago