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 > '202211' and rev_timestamp < '202212' 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) nov
    JOIN (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) dec ON nov.ip = dec.ip
;

SQL

Checking query status...