Comment search

SQL

SET STATEMENT max_statement_time = 60 FOR
SELECT
  actor_name,
  rev_id,
  comment_text
FROM
  revision_userindex AS revision
  INNER JOIN change_tag ON revision.rev_id = change_tag.ct_rev_id
  INNER JOIN change_tag_def ON change_tag.ct_tag_id = change_tag_def.ctd_id
  INNER JOIN comment ON revision.rev_comment_id = comment.comment_id
  INNER JOIN actor_revision AS actor ON revision.rev_actor = actor.actor_id
WHERE
  TRUE
  AND actor_user IS NOT NULL
  AND change_tag_def.ctd_name = 'visualeditor'
  AND comment_text = 'add cit, grammar'
ORDER BY rc_timestamp DESC;
SQL

Checking query status...
