Administrators by editcount on plwiki

SQL

USE plwiki_p;
SELECT
	COUNT(*) AS TOTAL,
	SUM(IF(user_editcount<10000, 1 , 0)) AS 10k,
	SUM(IF(user_editcount>=10000 AND user_editcount<20000, 1 , 0)) AS 20k,
	SUM(IF(user_editcount>=20000 AND user_editcount<30000, 1 , 0)) AS 30k,
	SUM(IF(user_editcount>=30000 AND user_editcount<40000, 1 , 0)) AS 40k,
	SUM(IF(user_editcount>=40000 AND user_editcount<50000, 1 , 0)) AS 50k,
	SUM(IF(user_editcount>50000, 1 , 0)) AS Over_50k
FROM user_groups
LEFT JOIN user ON ug_user = user_id
WHERE ug_group = 'sysop';

SQL

Checking query status...