We miss you! (cswiki)

SQL

USE cswiki_p;
SELECT user_name, count(created.rev_page), user_editcount
	FROM user
	JOIN (SELECT * FROM revision WHERE rev_parent_id = 0) AS created
		ON created.rev_user = user_id
	JOIN (SELECT * FROM page WHERE page_namespace = 0 AND page_is_redirect = 0) AS page1
		ON page1.page_id = created.rev_page
	LEFT JOIN user_groups
		ON ug_user = user_id
	LEFT JOIN (SELECT * FROM revision WHERE rev_timestamp > 20140600000000) AS edits
		ON edits.rev_user = user_id
WHERE rev2.rev_user IS NULL AND ug_group <> 'bot'
GROUP BY user_name HAVING (count(created.rev_page) > 100 OR user_editcount > 2000)
ORDER BY count(rev1.rev_page) DESC;
SQL

Checking query status...
