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
.
Counts of Fastily's deletions of pages in userspace since his resysop in December 2016, grouped by deletion comment. Anything after ']]:' is replaced by ' ...', so that there aren't a zillion different variants of e.g. '[[WP:CSD#G8|G8]]: Redirect to deleted page "Template:Chart/cellqt" ([[WP:TW|TW]])' each with a count of 1. For the curious: * The deletion log '3.' was immediately restored and then redeleted with a proper summary. * 'oops misclick' referred to an accidental restoration of a page another admin had deleted as a G10. * The six deletions mentioning G11 were: ** 2017-01-04 06:43:15 [[User:Tdankovy]] ** 2017-02-09 22:03:21 [[User:Vinivo/sandbox/Vinivo]] (the G11/U5) ** 2017-03-30 08:33:08 [[User:Lord pasha]] (one of the U5/G11s) ** 2017-11-05 19:29:30 [[User:Ranjith01]] (the other U5/G11) ** 2021-07-30 07:51:15 [[User:Deep-learning-fan/sandbox/Laurence Moroney]] ** 2022-07-05 21:23:26 [[User:Megan91williams/sandbox]] For [[WP:ANI#Fastily]] circa 4 November 2024. And apparently [[Wikipedia:Administrator recall/Fastily]] now too, sigh.
Toggle Highlighting
SQL
SELECT COUNT(*), REGEXP_REPLACE(comment_text, '\\]\\]:.*', ']]: ...') FROM logging_userindex JOIN actor_logging ON actor_id = log_actor LEFT JOIN comment_logging ON comment_id = log_comment_id WHERE actor_name = 'Fastily' AND log_timestamp >= '201612' AND log_type = 'delete' AND log_action = 'delete' AND log_namespace = 2 GROUP BY 2;
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...