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

SQL

AخA
 
SELECT CONCAT('[[User:', REPLACE(log_title, '_', ' '), ']]') AS pagename,
       GROUP_CONCAT(CONCAT('[[WP:', REPLACE(page_title, '_', ' '), ']]') SEPARATOR ', ') AS drvpages
FROM logging_userindex
JOIN actor_logging ON actor_id = log_actor
STRAIGHT_JOIN linktarget ON lt_namespace = log_namespace AND lt_title = log_title
STRAIGHT_JOIN pagelinks ON pl_target_id = lt_id AND pl_from_namespace = 4
STRAIGHT_JOIN page ON page_id = pl_from
STRAIGHT_JOIN comment_logging ON comment_id = log_comment_id
WHERE actor_name = 'Fastily'
  AND log_type = 'delete' AND log_action = 'delete'
  AND log_namespace = 2
  AND page_namespace = 4
  AND page_title LIKE 'Deletion\_review/Log/%\_%\_%'
  AND comment_text LIKE '%U5%'
GROUP BY log_title;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...