Untitled query #75025

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 = 'GWA88'
  AND page_namespace = 100
  AND r.rev_len < p.rev_len - 100
GROUP BY page_title
HAVING COUNT(*) >= 2
ORDER BY r.rev_timestamp;
SQL

Checking query status...
