Comment search

SQL

SET STATEMENT max_statement_time = 1200 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 ctd_name = 'visualeditor'
  AND comment_text = 'added inline cit'
  AND rev_timestamp >= 20160101000000
  AND rev_timestamp <= 20170101000000
-- ORDER BY rev_timestamp DESC
SQL

Checking query status...
