Deleted contributions

SQL

SET STATEMENT max_statement_time = 90 FOR
SELECT
  actor_name,
  comment_text
  -- COUNT(*)
FROM
  revision_userindex AS revision
  INNER JOIN page ON revision.rev_page = page.page_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 page_namespace IN (2, 3)
  AND (
    comment_text IN ('Created page with "{{userpage}}"', 'Created page with "{{Userpage}}"')
    OR comment_text IN ('Created page with "{{Talkpage}}"', 'Created page with "{{Talk header}}"')
    OR comment_text LIKE '%Nuova pagina: {{Pagina utente}}'
  )
-- GROUP BY actor_name
-- HAVING COUNT(*) >= 2
LIMIT 1
SQL

Checking query status...
