Number of ipblocks created/updated since 2023/01/01

SQL

SELECT COUNT(*) FROM
    (SELECT DISTINCT a.actor_name AS ip FROM
        (SELECT rev_timestamp, rev_actor FROM revision WHERE rev_timestamp > '202212' and rev_timestamp < '202301' AND rev_deleted = 0) r
            JOIN (SELECT actor_id, actor_name FROM actor WHERE actor_user IS NULL) a ON r.rev_actor = a.actor_id) d
    JOIN (SELECT DISTINCT a.actor_name AS ip FROM
        (SELECT rev_timestamp, rev_actor FROM revision WHERE rev_timestamp > '202301' and rev_timestamp < '202302' AND rev_deleted = 0) r
            JOIN (SELECT actor_id, actor_name FROM actor WHERE actor_user IS NULL) a ON r.rev_actor = a.actor_id) jan ON jan.ip = d.ip
;

SQL

Checking query status...