Untitled query #76251

SQL

SELECT
    actor.actor_name AS name,
    MIN(revision_userindex.rev_id) AS rev_undo,
    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 prefixed_page_title,
    MIN(revision_userindex.rev_parent_id) AS rev_undoafter,
    change_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 actor.actor_name = 'Gerges'
AND revision_userindex.rev_parent_id != 0
GROUP BY page.page_title;
SQL

Checking query status...
