English Wiktionary namespaces

SQL

-- Generated from siteinfo-namespaces in the dump; namespaces.name is the local name, not the canonical name.
with namespaces(id, name) as (
  values
  	(-2, 'Media'),
    (-1, 'Special'),
    (0, ''),
    (1, 'Talk'),
    (2, 'User'),
    (3, 'User talk'),
    (4, 'Wiktionary'),
    (5, 'Wiktionary talk'),
    (6, 'File'),
    (7, 'File talk'),
    (8, 'MediaWiki'),
    (9, 'MediaWiki talk'),
    (10, 'Template'),
    (11, 'Template talk'),
    (12, 'Help'),
    (13, 'Help talk'),
    (14, 'Category'),
    (15, 'Category talk'),
    (90, 'Thread'),
    (91, 'Thread talk'),
    (92, 'Summary'),
    (93, 'Summary talk'),
    (100, 'Appendix'),
    (101, 'Appendix talk'),
    (102, 'Concordance'),
    (103, 'Concordance talk'),
    (104, 'Index'),
    (105, 'Index talk'),
    (106, 'Rhymes'),
    (107, 'Rhymes talk'),
    (108, 'Transwiki'),
    (109, 'Transwiki talk'),
    (110, 'Thesaurus'),
    (111, 'Thesaurus talk'),
    (114, 'Citations'),
    (115, 'Citations talk'),
    (116, 'Sign gloss'),
    (117, 'Sign gloss talk'),
    (118, 'Reconstruction'),
    (119, 'Reconstruction talk'),
    (828, 'Module'),
    (829, 'Module talk'),
    (2300, 'Gadget'),
    (2301, 'Gadget talk'),
    (2302, 'Gadget definition'),
    (2303, 'Gadget definition talk')
)
select
	page_id as id,
    replace(if(source_namespace.name = '', page_title, concat(source_namespace.name, ':', page_title)), '_', ' ') as title,
    replace(concat(
      if(rd_interwiki = '', '', concat(rd_interwiki, ':')),
      if(target_namespace.name = '', '', concat(target_namespace.name, ':')),
      page_title
    ), '_', ' ') as redirect_target,
    page_random,
    page_content_model as content_model
from page
left join namespaces as source_namespace on source_namespace.id = page_namespace
left join redirect on rd_from = page_id
left join namespaces as target_namespace on target_namespace.id = rd_namespace
where page_random between 0.0002 and 0.0002135
order by page_namespace, page_title;
SQL

Checking query status...
