Largest module subdirectories in English Wiktionary

SQL

select
  substring_index(
    page_title,
    '/',
    if(instr(page_title, 'zh/') = 1, 3, 1)) as subpage,
   format(sum(page_len), 0) as size
   /*
   if(sum(page_len) > 1024 * 1024,
      concat(sum(page_len) / (1024 * 1024), ' MiB'),
      if(sum(page_len) > 1024,
         concat(sum(page_len) / 1024, ' KiB'),
         concat(sum(page_len), ' B'))) as binary_size,
   if(sum(page_len) > 1000 * 1000,
      concat(sum(page_len) / (1000 * 1000), ' MB'),
      if(sum(page_len) > 1000,
         concat(sum(page_len) / 1000, ' KB'),
         concat(sum(page_len), ' B'))) as decimal_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...
