Links from 2006 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 monthly summary pages (since it started using them in February 2006, until it switched to daily logs in December 2006) and showing only pages that RHaworth has ever deleted.

This should be more accurate than query 41073 (showing links from DRV from Dec 2006 onward), since only links to the reviewed pages and closing summaries are present; nevertheless, the disclaimers at #41073 still apply here.

SQL

SELECT * FROM actor_logging WHERE actor_name = 'RHaworth';

SELECT CONCAT('[[WP:', page_title, ']]') AS 'DRV',
       CONCAT('[[', CASE log_namespace
                      WHEN 0 THEN ''
                      WHEN 1 THEN 'Talk:'
                      WHEN 2 THEN 'User:'
                      WHEN 3 THEN 'User talk:'
                      WHEN 4 THEN 'Wikipedia:'
                      WHEN 5 THEN 'Wikipedia talk:'
                      WHEN 6 THEN ':File:'
                      WHEN 7 THEN 'File talk:'
                      WHEN 10 THEN 'Template:'
                      WHEN 11 THEN 'Template talk:'
                      WHEN 14 THEN ':Category:'
                      WHEN 15 THEN 'Category talk:'
                      WHEN 118 THEN 'Draft:'
                      WHEN 119 THEN 'Draft talk:'
                      ELSE CONCAT('{{ns:', log_namespace, '}}:')
                    END, log_title, ']]') AS 'page',
       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_logging 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 LIKE 'Deletion_review/Recently_concluded_(2006_%';

SQL

Checking query status...