Untitled query #76320

SQL

SELECT
    CONCAT(
        CASE
            WHEN page.page_namespace = 2303 THEN 'Gadget definition talk:'
            WHEN page.page_namespace = 2302 THEN 'Gadget definition:'
            WHEN page.page_namespace = 2301 THEN 'Gadget talk:'
            WHEN page.page_namespace = 2300 THEN 'Gadget:'
            WHEN page.page_namespace = 829 THEN 'Module talk:'
            WHEN page.page_namespace = 828 THEN 'Module:'
            WHEN page.page_namespace = 710 THEN 'TimedText:'
            WHEN page.page_namespace = 711 THEN 'TimedText talk:'
            WHEN page.page_namespace = 119 THEN 'Draft talk:'
            WHEN page.page_namespace = 118 THEN 'Draft:'
            WHEN page.page_namespace = 101 THEN 'Portal talk:'
            WHEN page.page_namespace = 100 THEN 'Portal:'
            WHEN page.page_namespace = 15 THEN 'Category talk:'
            WHEN page.page_namespace = 14 THEN 'Category:'
            WHEN page.page_namespace = 13 THEN 'Help talk:'
            WHEN page.page_namespace = 12 THEN 'Help:'
            WHEN page.page_namespace = 11 THEN 'Template talk:'
            WHEN page.page_namespace = 10 THEN 'Template:'
            WHEN page.page_namespace = 9 THEN 'MediaWiki talk:'
            WHEN page.page_namespace = 8 THEN 'MediaWiki:'
            WHEN page.page_namespace = 7 THEN 'File talk:'
            WHEN page.page_namespace = 6 THEN 'File:'
            WHEN page.page_namespace = 5 THEN 'Wikipedia talk:'
            WHEN page.page_namespace = 4 THEN 'Wikipedia:'
            WHEN page.page_namespace = 3 THEN 'User talk:'
            WHEN page.page_namespace = 2 THEN 'User:'
            WHEN page.page_namespace = 1 THEN 'Talk:'
            WHEN page.page_namespace = 0 THEN ''
        END,
        page.page_title
    ) AS page_title,
    actor.actor_name,
    revision_userindex.rev_timestamp,
    COUNT(hange_tag_def.ctd_name)
    
    
FROM revision_userindex
INNER JOIN actor ON actor.actor_id = revision_userindex.rev_actor
INNER JOIN page ON page.page_id = revision_userindex.rev_page
INNER JOIN change_tag ON change_tag.ct_rev_id = revision_userindex.rev_id
INNER JOIN change_tag_def ON change_tag_def.ctd_id = change_tag.ct_tag_id
WHERE revision_userindex.rev_parent_id != 0
AND change_tag_def.ctd_name != 'mw-reverted'
AND change_tag_def.ctd_name = 'وصلات_خارجية_للمراجعة_2'
GROUP BY actor.actor_name;
SQL

Checking query status...
