Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Gerges
.
Toggle Highlighting
SQL
SELECT actor.actor_name AS name, MIN(revision_userindex.rev_id) AS rev_undo, 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 AS page_prefix, page.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 page.page_namespace IN (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 100, 101, 118, 119, 710, 711, 828, 829, 2300, 2301, 2302, 2303) AND revision_userindex.rev_parent_id != 0 GROUP BY page.page_title, page.page_namespace;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...