Comment search

SQL

SET STATEMENT max_statement_time = 600 FOR
SELECT
  rev_timestamp,
  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 rev_minor_edit = 0
  AND change_tag_def.ctd_name = 'visualeditor'
  -- AND comment_text = 'add cit, grammar'
-- ORDER BY rev_timestamp DESC
LIMIT 1;
SQL

Checking query status...
