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

SQL

SELECT
    u.user_name,
    u.user_registration,
	CASE WHEN r.num_revisions IS NULL THEN 0 ELSE r.num_revisions END AS revisions
FROM (
    	SELECT
    		ipb_by_actor AS actor_id,
    		COUNT(*) AS num_blocks
		FROM
		    ipblocks b
		WHERE
		    b.ipb_timestamp > '2022' AND b.ipb_timestamp < '2023'
		GROUP BY
		    ipb_by_actor
		ORDER BY
		    num_blocks DESC
		LIMIT 100
    ) b LEFT JOIN actor a ON a.actor_id = b.actor_id
    	LEFT JOIN (
      		SELECT
      			rev_actor AS rev_actor,
      			COUNT(*) AS num_revisions
      		FROM
      			revision
      		GROUP BY rev_actor
    	) r ON b.actor_id = r.rev_actor LEFT JOIN user u ON u.user_id = a.actor_user
;

SQL

Checking query status...