Blocks on nl wiki

SQL

USE nlwiki_p;
SELECT
CASE
	WHEN ipb_expiry = 'infinity' THEN 'infinity'
	WHEN ipb_expiry-ipb_timestamp = 1000000 THEN '1 Day'
	WHEN ipb_expiry-ipb_timestamp = 83000000 THEN '1 Month'
	WHEN ipb_expiry-ipb_timestamp = 10000000000 THEN '2 Years'
	WHEN ipb_expiry-ipb_timestamp = 20000000000 THEN '2 Years'
	ELSE CONCAT( ipb_timestamp, ' - ', ipb_expiry, '   ', ipb_expiry-ipb_timestamp )
END AS 'Length',
CASE
	WHEN ipb_range_start = '' THEN 'account'
	WHEN ipb_range_start = ipb_range_end THEN 'ip'
	ELSE 'range'
END AS 'Type',
COUNT(*) FROM ipblocks
WHERE ipb_timestamp > 20190821000000
GROUP BY CONCAT( CASE
	WHEN ipb_expiry = 'infinity' THEN 'infinity'
	WHEN ipb_expiry-ipb_timestamp = 1000000 THEN '1 Day'
	WHEN ipb_expiry-ipb_timestamp = 83000000 THEN '1 Month'
	WHEN ipb_expiry-ipb_timestamp = 20000000000 THEN '2 Years'
	ELSE CONCAT( ipb_timestamp, ' - ', ipb_expiry, '   ', ipb_expiry-ipb_timestamp )
END,
CASE
	WHEN ipb_range_start = '' THEN 'account'
	WHEN ipb_range_start = ipb_range_end THEN 'ip'
	ELSE 'range'
END )
SQL

Checking query status...
