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
Cryptic
.
Creators of any of a list of pages, some currently deleted, some currently existing. For [[Wikipedia:Sockpuppet investigations/Devoter]] circa 25 July 2024.
Toggle Highlighting
SQL
-- currently-deleted pages SELECT CONCAT('[[', REPLACE(ar_title, '_', ' '), ']]') AS title, CONCAT('[[User:', actor_name, ']]') AS creator, CAST(ar_timestamp AS DATETIME) AS timestamp FROM archive JOIN actor_archive ON actor_id = ar_actor WHERE ar_namespace = 0 AND ar_parent_id = 0 AND ar_title IN ('DJ_Kamal_Mustafa', 'Kamal_Mustafa_(filmmaker)', 'Kamal_Mustafa_(DJ)', 'Operation_Swift_Retort_(2019_Film)', 'Operation_Swift_Retort_(short_film)', 'Operation_Swift_Retort_(film)') UNION -- currently-existing pages SELECT CONCAT('[[', REPLACE(page_title, '_', ' '), ']]'), CONCAT('[[User:', actor_name, ']]'), CAST(rev_timestamp AS DATETIME) FROM revision JOIN page ON page_id = rev_page JOIN actor_revision ON actor_id = rev_actor WHERE page_namespace = 0 AND rev_parent_id = 0 AND page_title IN ('DJ_Kamal_Mustafa', 'Kamal_Mustafa_(filmmaker)', 'Kamal_Mustafa_(DJ)', 'Operation_Swift_Retort_(2019_Film)', 'Operation_Swift_Retort_(short_film)', 'Operation_Swift_Retort_(film)') ORDER BY timestamp;
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...