Image rotate requests by users with low editcount (recentchanges)

SQL

USE commonswiki_p;
SET max_statement_time = 300;

SELECT
  CONCAT(
    '# [https://commons.wikimedia.org/w/index.php?title=File:',
    page_title,
    '&action=history',
    ' ','comment_text',']'
  ) AS rev_link
 -- , rev_id COUNT(*)
FROM
  revision
  JOIN actor ON rev_actor = actor.actor_id 
  -- JOIN user AS u ON u.user_id = a.actor_user
  JOIN page ON rev_page = page_id
  AND page_namespace = 6
  AND page_is_redirect = 0
WHERE
  --  gu_home_db = 'commonswiki'
  -- AND u.user_editcount < 9
   (select comment.comment_text from comment where comment.comment_id = rev_comment_id) LIKE 'Requesting rotation %'
GROUP BY rev_link

SQL

Checking query status...