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