Most transcluded namespaces in English Wiktionary entries

SQL

with namespace(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_namespace as namespace_number, namespace.name as namespace_name, count(tl_from) as transclusions
from templatelinks
left join linktarget on lt_id = tl_target_id
left join page on page_id = tl_from
left join namespace on namespace.id = page_namespace
where page_namespace = 0 or page_namespace = 114 # links from main or Reconstruction namespace
group by page_namespace
order by transclusions desc
SQL

Checking query status...
