Deleted contributions

SQL

SET STATEMENT max_statement_time = 90 FOR
SELECT
  actor_name,
  COUNT(*)
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 IN (2, 3)
  AND (
    comment_text IN ('Created page with "{{userpage}}"', 'Created page with "{{Userpage}}"',
                    '[[WP:OA|←]]Nuova pagina: {{Pagina utente}}')
    OR comment_text IN ('Created page with "{{Talkpage}}"', 'Created page with "{{Talk header}}"',
                       '[[WP:OA|←]]Nuova pagina: {{Discussione}}')
  )
GROUP BY actor_name
HAVING COUNT(*) >= 2
SQL

Checking query status...
