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 = 72000000 THEN '3 days'
	WHEN ipb_expiry-ipb_timestamp IN (7000000, 7000731, 76000000, 83000000) THEN '1 week'
	WHEN ipb_expiry-ipb_timestamp = 7000731 THEN '1 week, 7 minutes, 31 seconds'
	WHEN ipb_expiry-ipb_timestamp = 100000000 THEN '1 month'
	WHEN ipb_expiry-ipb_timestamp = 300000000 THEN '3 months'
    WHEN ipb_expiry-ipb_timestamp IN (600010000, 9400010000) THEN '6 months, 1 hour'
    WHEN ipb_expiry-ipb_timestamp > 9999043209 THEN CONCAT( (ipb_expiry-ipb_timestamp) / 10000000000, ' year(s)' )
	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(*) AS 'Number'
FROM ipblocks
WHERE ipb_timestamp > 20190601000000
AND ipb_auto <> 1
GROUP BY CONCAT( CASE
	WHEN ipb_expiry = 'infinity' THEN 'infinity'
	WHEN ipb_expiry-ipb_timestamp = 1000000 THEN '1 day'
    WHEN ipb_expiry-ipb_timestamp = 72000000 THEN '3 days'
	WHEN ipb_expiry-ipb_timestamp IN (7000000, 7000731, 76000000, 83000000) THEN '1 week'
	WHEN ipb_expiry-ipb_timestamp = 7000731 THEN '1 week, 7 minutes, 31 seconds'
	WHEN ipb_expiry-ipb_timestamp = 100000000 THEN '1 month'
	WHEN ipb_expiry-ipb_timestamp = 300000000 THEN '3 months'
    WHEN ipb_expiry-ipb_timestamp IN (600010000, 9400010000) THEN '6 months, 1 hour'
    WHEN ipb_expiry-ipb_timestamp > 9999043209 THEN CONCAT( (ipb_expiry-ipb_timestamp) / 10000000000, ' year(s)' )
END,
CASE
	WHEN ipb_range_start = '' THEN 'account'
	WHEN ipb_range_start = ipb_range_end THEN 'ip'
	ELSE 'range'
END )
ORDER BY COUNT(*) DESC
SQL

Checking query status...
