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 page ON revision.rev_page = page.page_id
  INNER JOIN comment_revision AS 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 page_namespace = 0
  AND actor_user IS NOT NULL
  -- AND rev_minor_edit = 0
  AND comment_hash IN (1968607863, -1747032970)
  AND rev_timestamp >= 20180101000000
  -- AND rev_timestamp <= 20170101000000
-- ORDER BY rev_timestamp DESC
SQL

Checking query status...
