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 * from namespaces;
SQL

Checking query status...
