Fastily's U5s linked from DRV

User pages that have ever been deleted by Fastily with a deletion log comment containing 'U5' and that are currently linked from at least one Deletion Review daily log subpage.

For [[Wikipedia:Administrator recall/Fastily]].

SQL

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;

SQL

Checking query status...