Deleted contributions

SQL

SET
  STATEMENT max_statement_time = 120 FOR
SELECT
  actor_name,
  comment_text,
  rev_timestamp
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
  INNER JOIN user ON user.user_id = actor.actor_user
WHERE
  rev_timestamp >= '20200101000000'
  AND (
    page_namespace = 2
    AND comment_text IN (
      'Created page with "{{userpage}}"',
      'Created page with "{{Userpage}}"',
      '[[WP:OA|←]]Nuova pagina: {{Pagina utente}}'
    )
  )
  OR (
    page_namespace = 3
    AND comment_text IN (
      'Created page with "{{Talkpage}}"',
      'Created page with "{{Talk header}}"',
      '[[WP:OA|←]]Nuova pagina: {{Discussione}}',
      'Página creada con «{{discusión}}»',
      '새 문서: {{토론 머리말}}'
    )
  )
  AND user_registration >= '20200101000000'
  AND user_registration < '20220301000000'
  -- AND user_registration >= '20201216203000'
  -- AND user_registration <  '20201216204000'
  AND user_name RLIKE '^(?:Aer|Ah|Al|Am|Ar|Art|Aur|Ba|Bai|Bar|Bare|Be|Ber|Bo|Bra|Brat|Bre|Breati|Breta|Bri|Bru|Bu|Cr|Cra|Cre|Cretia|Der|Derain|Dr|Dre|Dri|Er|Erat|Fer|Fra|Fre|Fret|Freta|Gh|Gr|Gu|Ha|Hart|Hu|Ja|Ka|Kai|Kaij|Kail|Kaiu|Kal|Kau|La|Lak|Ma|Mai|Mau|Maur|Me|Meri|Meritan|Mi|Mo|Nar|Ne|Ner|Neri|Neria|Ni|Ra|Rae|Raer|Rati|Ratis|Re|Rea|Reat|Reatin|Ren|Reta|Ri|Rta|Si|Swap|Ta|Te|Tra|Trei|Va|Var|Vare|Vr|Vre|Vrea|Yrats|Ytars)[abcdefghijklmnoprstuvwxyz]+(?:ain|aisn|ak|akis|al|am|an|ani|anik|ans|anski|arn|as|ating|di|ean|er|esin|et|etan|hal|ia|ial|ian|ians|ik|il|in|ina|inali|ini|ins|instan|io|ir|is|isa|isn|itan|ji|la|lan|lian|lins|na|nal|ni|nia|nik|nis|nl|no|ns|nsai|nsi|nsin|nt|ntan|oan|osn|ran|ratsian|ri|rin|ruians|sal|san|sh|si|sian|sik|sin|sina|slan|sn|snal|st|stan|stin|tain|tal|tan|tansil|tas|tin|tral|tsina|us|utan|yal)$'
  -- AND user_name RLIKE '^[A-Z][a-z]+$'
  AND LENGTH(user_name) <= 11
  AND LENGTH(user_name) >= 6
  AND user_editcount > 0
SQL

Checking query status...
