Deleted contributions

This query is marked as a draft This query has been published by MarioGom.
SQL

SET
  STATEMENT max_statement_time = 200 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}}',
      'Página creada con «{{Babel|en-2|es-2|ru-3}}»'
    )
  )
  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_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 LENGTH(user_name) <= 11
  AND LENGTH(user_name) >= 6
  AND actor_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 LENGTH(actor_name) <= 11
  AND LENGTH(actor_name) >= 6
  AND user_editcount > 0
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
