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',
    ' ',rev_comment,']'
  ) AS rev_link
 -- , rev_id COUNT(*)
FROM
  revision
  JOIN actor a ON a.actor_id == rev_actor
  JOIN user 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 rev_len > '2000'
  AND u.user_editcount < 9
  rev_comment LIKE 'Requesting rotation %'
GROUP BY rev_link

SQL

Checking query status...