We miss you! (cswiki)

SQL

USE hsbwiki_p;
SELECT latest.rev_user_text, last_edit, user_editcount, IFNULL(articles_created, 0)
	FROM (SELECT *, MAX(rev_timestamp) AS last_edit FROM revision WHERE rev_user > 0 GROUP BY rev_user) AS latest
	JOIN user
		ON user_id = latest.rev_user
	LEFT JOIN (SELECT *, COUNT(*) AS articles_created
               FROM revision
               JOIN page
               WHERE rev_parent_id = 0 AND page_namespace = 0
               GROUP BY rev_user) AS created
		ON created.rev_user = latest.rev_user
WHERE last_edit < DATE_ADD(NOW(), INTERVAL -1 YEAR)
ORDER BY last_edit DESC
LIMIT 50;
SQL

Checking query status...
