English Wiktionary namespaces

SQL

with namespaces(id, local_name, canonical_name, is_talk) as (
  values
  	(-2, 'Media', 'Media', false),
    (-1, 'Special', 'Special', false),
    (0, '', '', false),
    (1, 'Talk', 'Talk', true),
    (2, 'User', 'User', false),
    (3, 'User talk', 'User talk', true),
    (4, 'Wiktionary', 'Project', false),
    (5, 'Wiktionary talk', 'Project talk', true),
    (6, 'File', 'File', false),
    (7, 'File talk', 'File talk', true),
    (8, 'MediaWiki', 'MediaWiki', false),
    (9, 'MediaWiki talk', 'MediaWiki talk', true),
    (10, 'Template', 'Template', false),
    (11, 'Template talk', 'Template talk', true),
    (12, 'Help', 'Help', false),
    (13, 'Help talk', 'Help talk', true),
    (14, 'Category', 'Category', false),
    (15, 'Category talk', 'Category talk', true),
    (90, 'Thread', 'Thread', false),
    (91, 'Thread talk', 'Thread talk', true),
    (92, 'Summary', 'Summary', false),
    (93, 'Summary talk', 'Summary talk', true),
    (100, 'Appendix', 'Appendix', false),
    (101, 'Appendix talk', 'Appendix talk', true),
    (102, 'Concordance', 'Concordance', false),
    (103, 'Concordance talk', 'Concordance talk', true),
    (104, 'Index', 'Index', false),
    (105, 'Index talk', 'Index talk', true),
    (106, 'Rhymes', 'Rhymes', false),
    (107, 'Rhymes talk', 'Rhymes talk', true),
    (108, 'Transwiki', 'Transwiki', false),
    (109, 'Transwiki talk', 'Transwiki talk', true),
    (110, 'Thesaurus', 'Thesaurus', false),
    (111, 'Thesaurus talk', 'Thesaurus talk', true),
    (114, 'Citations', 'Citations', false),
    (115, 'Citations talk', 'Citations talk', true),
    (116, 'Sign gloss', 'Sign gloss', false),
    (117, 'Sign gloss talk', 'Sign gloss talk', true),
    (118, 'Reconstruction', 'Reconstruction', false),
    (119, 'Reconstruction talk', 'Reconstruction talk', true),
    (828, 'Module', 'Module', false),
    (829, 'Module talk', 'Module talk', true),
    (2300, 'Gadget', 'Gadget', false),
    (2301, 'Gadget talk', 'Gadget talk', true),
    (2302, 'Gadget definition', 'Gadget definition', false),
    (2303, 'Gadget definition talk', 'Gadget definition talk', true)
)
select page_id, replace(if(namespaces.local_name = '', page_title, concat(namespaces.local_name, ':', page_title)), '_', ' ') as title, page_random, page_content_model from page
left join namespaces on namespaces.id = page_namespace
where page_random between 0.0001 and 0.00015;
SQL

Checking query status...
