Largest module subdirectories in English Wiktionary

SQL

select if(instr(page_title, 'zh/') = 1, substring_index(page_title, '/', 3), substring_index(page_title, '/', 1)) as subpage, format_bytes(sum(page_len)) as size
from page

# Module
where page_namespace = 828

# Module name doesn't end with /documentation
and (instr(page_title, '/documentation') = 0 or instr(page_title, '/documentation') + length('/documentation') <> length(page_title) + 1)

group by
  substring_index(
    page_title,
    '/',
    if(instr(page_title, 'zh/') = 1, 3, 1))
order by sum(page_len) desc;

select sum(page_len) as 'user sandbox module size' from page
where page_namespace = 828 and instr(page_title, 'User:') = 1;

SQL

Checking query status...