Fastily's userspace deletions by comment

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.

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;

AخA
 
SELECT COUNT(*), REGEXP_REPLACE(comment_text, '\\]\\]:.*', ']]: ...')FROM logging_userindexJOIN actor_logging ON actor_id = log_actorLEFT JOIN comment_logging ON comment_id = log_comment_idWHERE actor_name = 'Fastily'  AND log_timestamp >= '201612'  AND log_type = 'delete' AND log_action = 'delete'  AND log_namespace = 2GROUP BY 2;

SQL

Checking query status...