Blocks on nl wiki

SQL

USE nlwiki_p;
SELECT ipb_address, ipb_user, ipb_timestamp, ipb_expiry,
CASE
	WHEN ipb_expiry = 'infinity' THEN 'infinity'
	ELSE ( ipb_expiry - ipb_timestamp) / 1000000
END AS 'Days',
CASE
	WHEN ipb_range_start IS NULL THEN 'account'
	WHEN ipb_range_start = ipb_range_end THEN 'ip'
	ELSE 'range'
END AS 'Type',
ipb_range_start, ipb_range_end, COUNT(*) FROM ipblocks
WHERE ipb_timestamp > 20190821000000
GROUP BY CONCAT( CASE
	WHEN ipb_range_start IS NULL THEN 'account'
	WHEN ipb_range_start = ipb_range_end THEN 'ip'
	ELSE 'range'
END, CASE
	WHEN ipb_expiry = 'infinity' THEN 'infinity'
	ELSE ( ipb_expiry - ipb_timestamp) / 1000000
END )
SQL

Checking query status...
