SQL
AخA
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.