We miss you! (cswiki)

SQL

USE cswiki_p;
SELECT recent.rev_id, recent.rev_page, recent.rev_comment, recent.rev_user, recent.rev_user_text, recent.rev_timestamp,
	recent.rev_parent_id, user_id, user_name
	FROM (SELECT * FROM revision WHERE rev_timestamp > 20140800000000 AND rev_user > 0) AS recent
	LEFT JOIN user
		ON user_id = recent.rev_user
#	LEFT JOIN (SELECT * FROM revision WHERE rev_parent_id = 0 AND rev_user > 0) AS created
#		ON created.rev_user = user_id
# WHERE recent.rev_id IS NULL
GROUP BY user_id
ORDER BY recent.rev_id DESC
LIMIT 50;

/*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 IS NOT NULL) AS recent
		ON recent.rev_user = user_id
#	LEFT JOIN (SELECT * FROM revision WHERE rev_parent_id = 0 AND rev_timestamp < 20140800000000 AND rev_user IS NOT NULL) 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
#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...
