-- SET STATEMENT max_statement_time = 90 FOR

SELECT DISTINCT

  actor_name,

  rc_this_oldid,

  comment_text

FROM

  recentchanges_userindex AS recentchanges

  INNER JOIN change_tag ON recentchanges.rc_id = change_tag.ct_rc_id

  INNER JOIN change_tag_def ON change_tag.ct_tag_id = change_tag_def.ctd_id

  INNER JOIN comment ON recentchanges.rc_comment_id = comment.comment_id

  INNER JOIN actor_recentchanges AS actor ON recentchanges.rc_actor = actor.actor_id

WHERE

  TRUE

  AND rc_type = 0

  -- AND rc_namespace = 0

  -- AND rc_ip IS NULL

  AND rc_bot = 0

  AND actor_user IS NOT NULL

  -- AND actor_user IS NULL

  -- AND change_tag_def.ctd_name = 'visualeditor'

  -- AND comment_text RLIKE '^(delet|remov)ed (broken|red) links?$'

  AND comment_text IN ('Evidence', 'Agd')

ORDER BY rc_timestamp DESC;