1ヶ月以上前に登録し、全名前空間を通じて50回以上編集しており、直近1ヶ月間に標準名前空間を5回以上編集しているアカウント

SQL

USE jawiki_p;
SELECT user_name, user_registration, user_editcount, COUNT(*) AS one_month_main_space, ipb_expiry
FROM user
	JOIN recentchanges_userindex ON user_id = rc_user
	JOIN revision_userindex ON user_id = rev_user
	LEFT JOIN ipblocks on ipb_user = user_id
WHERE user_editcount >= 50
AND (user_registration IS NULL OR user_registration < REGEXP_REPLACE(DATE_SUB(NOW(), INTERVAL 1 month), "[ :\-]", ""))
AND rc_timestamp > REGEXP_REPLACE(DATE_SUB(NOW(), INTERVAL 1 month), "[ :\-]", "")
AND rc_namespace = 0
GROUP BY user_id
HAVING COUNT(rc_id) >= 5
HAVING COUNT(rev_id) >= 50
ORDER BY user_editcount DESC;

SQL

Checking query status...