Links from DRV to pages deleted by RHaworth

This query is marked as a draft This query has been published by Cryptic.

For [[Wikipedia:Arbitration/Requests/Case/RHaworth/Evidence]].

There are many, many false positives - this is the equivalent of going to [[Special:Whatlinkshere]] for each of DRV's daily log pages (since it started using daily logs in December 2006) and showing only pages that RHaworth has ever deleted.

The DRV itself may or may not have had anything to do with RHaworth's deletion (for example, [[Category:Australian soccer players]] was speedied by RHaworth in 2005 as a C1:empty category; the deletion review was of a 2007 CFD renaming [[Category:Australian football (soccer) players]] to that title) or even that *page* (for example, [[User:Yoenit]] appears here because RHaworth once deleted their user page, and they later commented at [[WP:Deletion review/Log/2010 October 20]]).

In particular, the total number of entries here is nearly meaningless; there's a separate row for each of RHaworth's deletions of a given page, and DRV will typically link to the (also-deleted) talk page.

See also query 41074, for links from DRV from February to November 2006.

SQL

SELECT * FROM actor_logging WHERE actor_name = 'RHaworth';

SELECT CONCAT('[[WP:', page_title, ']]') AS 'DRV', log_namespace, log_title, log_timestamp, comment_text
FROM logging_userindex
  JOIN pagelinks ON pl_namespace=log_namespace AND pl_title=log_title
  JOIN page ON page_id=pl_from
  LEFT JOIN comment_log ON comment_id=log_comment_id
WHERE log_type='delete' AND log_action='delete' AND log_actor=2933
  AND page_namespace=4 AND page_title RLIKE '^Deletion_review/Log/20[0-9][0-9]_[A-Z][a-z]+_[0-9]+$'
  AND NOT (log_namespace=3 AND log_title='RHaworth');

​x
 
SELECT * FROM actor_logging WHERE actor_name = 'RHaworth';​SELECT CONCAT('[[WP:', page_title, ']]') AS 'DRV', log_namespace, log_title, log_timestamp, comment_textFROM logging_userindex  JOIN pagelinks ON pl_namespace=log_namespace AND pl_title=log_title  JOIN page ON page_id=pl_from  LEFT JOIN comment_log ON comment_id=log_comment_idWHERE log_type='delete' AND log_action='delete' AND log_actor=2933  AND page_namespace=4 AND page_title RLIKE '^Deletion_review/Log/20[0-9][0-9]_[A-Z][a-z]+_[0-9]+$'  AND NOT (log_namespace=3 AND log_title='RHaworth');

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.

SQL

Checking query status...