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_%';