We miss you! (cswiki)

SQL

USE cswiki_p;
SELECT user_name, /*COUNT(DISTINCT created.rev_page) AS created,*/ user_editcount AS edits
	FROM (SELECT * FROM user WHERE user_editcount > 10) AS users
	LEFT JOIN (SELECT * FROM revision WHERE rev_timestamp > 20140800000000 AND rev_user > 0) AS recent
		ON recent.rev_user_text = user_name
#	LEFT JOIN (SELECT * FROM revision WHERE rev_parent_id = 0 AND rev_timestamp < 20140800000000 AND rev_user > 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 (SELECT * FROM user_groups WHERE ug_group = 'bot') AS bots
#		ON ug_user = user_id
#	LEFT JOIN (SELECT * FROM revision WHERE rev_timestamp > 20140800000000) AS edits
#		ON recent.rev_user = user_id
WHERE recent.rev_user_text IS NULL# AND ug_group IS NULL
#GROUP BY user_name# HAVING (COUNT(DISTINCT created.rev_page) > 100 OR user_editcount > 2000)
ORDER BY /*created DESC,*/ edits DESC, user_name;
SQL

Checking query status...
