Ancient non-mainspace English Wiktionary pages

SQL

select
	replace(concat(
        if(page_namespace_name = '', '', concat(page_namespace_name, ':')),
        page_title
    ), '_', ' ') as page_full_title,
    replace(concat(
        if(redirect_target_interwiki = '', '', concat(redirect_target_interwiki, ':')),
        if(redirect_target_namespace_name = '', '', concat(redirect_target_namespace_name, ':')),
        redirect_target_title
    ), '_', ' ') as redirect_target_full_title,
    date_format(page_last_edit_timestamp, '%Y-%m-%d %H:%i:%s') as last_edited,
    
    -- link using page ID (not really necessary now that the query contains page_full_title)
    concat('en.wiktionary.org?curid=', page_id) as url,
    
    -- fields only useful for sorting
	page_title,
	page_namespace,
    redirect_target_title,
    redirect_target_namespace
from (
    -- 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_namespace,
        page_namespace.name as page_namespace_name,
        page_title,
        page_id,
        rev_timestamp as page_last_edit_timestamp,
        rd_interwiki as redirect_target_interwiki,
        rd_namespace as redirect_target_namespace,
        redirect_target_namespace.name as redirect_target_namespace_name,
        rd_title as redirect_target_title
    from page
    join revision on rev_id = page_latest
    left join namespaces as page_namespace on page_namespace.id = page_namespace
    left join redirect on rd_from = page_id
    left join namespaces as redirect_target_namespace on redirect_target_namespace.id = rd_namespace
    where page_latest <> 0
    and page_namespace <> 0
    and rev_timestamp < '2008'
    order by rev_timestamp asc
) as tmp
order by page_last_edit_timestamp asc;
SQL

Checking query status...
