Potential 3RR by Alsoriano97

Pages in the Portal namespace where Alsoriano97 has four or more edits that each remove more than 50 bytes.

Not all of these are 3RR breaches, or even edit warring; there's no attempt to limit to 24-hour timespans, and this can't identify (for example) removals of outright vandalism.

For [[WP:Arbitration/Requests/Case#Statement by Cryptic]] circa [[Special:Permalink/1104440759]] on 15 August 2022.

SQL

SELECT COUNT(r.rev_id) AS '#/edits',
       CONCAT('Portal:', page_title) AS 'page',
       CAST(MIN(r.rev_timestamp) AS DATETIME) AS 'first timestamp',
       CAST(MAX(r.rev_timestamp) AS DATETIME) AS 'last timestamp',
FROM revision_userindex AS r
JOIN revision AS p ON p.rev_id = r.rev_parent_id
JOIN actor_revision ON actor_id = r.rev_actor
JOIN page ON page_id = r.rev_page
WHERE actor_name = 'Alsoriano97'
  AND page_namespace = 100
  AND r.rev_len < p.rev_len - 50
GROUP BY page_title
HAVING COUNT(*) >= 4
ORDER BY r.rev_timestamp;

SQL

Checking query status...