Links from DRV to pages deleted by RHaworth

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
FROM logging_userindex
  JOIN pagelinks ON pl_namespace=log_namespace AND pl_title=log_title
  JOIN page ON page_id=pl_from
WHERE log_type='delete' AND log_action='delete' AND log_actor=2933
  AND page_namespace=4 AND page_title LIKE 'Deletion_review/Log/%';

​x
 
SELECT * FROM actor_logging WHERE actor_name = 'RHaworth';​SELECT CONCAT('[[WP:', page_title, ']]') AS 'DRV', log_namespace, log_title, log_timestampFROM logging_userindex  JOIN pagelinks ON pl_namespace=log_namespace AND pl_title=log_title  JOIN page ON page_id=pl_fromWHERE log_type='delete' AND log_action='delete' AND log_actor=2933  AND page_namespace=4 AND page_title LIKE 'Deletion_review/Log/%';

SQL

Checking query status...