Ancient non-mainspace English Wiktionary pages

SQL

-- Generated from siteinfo-namespaces in the dump; namespaces.name is the local name, not the canonical name.
select
	source_title,
	source_namespace,
	replace(concat(
        if(source_namespace_name = '', '', concat(source_namespace_name, ':')),
        source_title
    ), '_', ' ') as title,
    target_namespace,
    replace(concat(
        if(target_interwiki = '', '', concat(target_interwiki, ':')),
        if(target_namespace_name = '', '', concat(target_namespace_name, ':')),
        target_title
    ), '_', ' ') as redirect_target_title,
    url,
    last_edited
from (
    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_namespace as source_namespace,
        source_namespace.name as source_namespace_name,
        page_title as source_title,
        concat('en.wiktionary.org?curid=', page_id) as url,
        date_format(rev_timestamp, '%Y-%m-%d %H:%i:%s') as last_edited,
        rd_interwiki as target_interwiki,
        rd_namespace as target_namespace,
        target_namespace.name as target_namespace_name,
        rd_title as target_title
    from page
    join revision on rev_id = page_latest
    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_latest <> 0
    and page_namespace <> 0
    order by rev_timestamp asc
    limit 5000
) as tmp;
SQL

Checking query status...
