aWa recent changes

SQL

-- 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
	date_format(rc_timestamp, '%Y-%m-%d %H:%i:%s') as timestamp,
    actor_name as user,
    replace(concat(
        if(namespace.name = '', '', concat(namespace.name, ':')),
        rc_title
    ), '_', ' ') as full_title,
    comment_text,
    rc_namespace as namespace,
    rc_title as title
from recentchanges

join namespaces as namespace on namespace.id = rc_namespace
left join actor on actor_id = rc_actor
left join page as category_member on page_id = rc_cur_id
left join comment on comment_id = rc_comment_id

where rc_type in (0, 1)
and comment_text like '%MediaWiki:Gadget-aWa.js%'
order by rc_timestamp desc
limit 1000;
SQL

Checking query status...
