We miss you! (cswiki)

SQL

USE cswiki_p;
DESCRIBE user;/*
SELECT user_name, first_edit, last_edit, user_editcount, articles_created
	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 ON page_id = rev_page
               WHERE rev_parent_id = 0 AND page_namespace = 0 GROUP BY rev_user) AS created
		ON created.rev_user = latest.rev_user
	JOIN (SELECT *, MIN(rev_timestamp) AS first_edit FROM revision WHERE rev_user > 0 GROUP BY rev_user) AS oldest
		ON oldest.rev_user = latest.rev_user
WHERE last_edit < DATE_ADD(NOW(), INTERVAL -1 YEAR)
AND (user_editcount > 2000 OR articles_created > 100)
#AND first_edit < DATE_ADD(NOW(), INTERVAL -3 YEAR)
AND user_name NOT LIKE '%[Bb][Oo][Tt]'
ORDER BY (articles_created * articles_created) + (user_editcount * 10)
LIMIT 100;*/
SQL

Checking query status...
