Untitled query #8745

SQL

USE jawiki_p;
SELECT user_name, user_registration, user_editcount, COUNT(rc_id) AS one_month_main_space
FROM user JOIN recentchanges_userindex ON user_id = rc_user
WHERE user_editcount >= 50
AND user_registration < REGEXP_REPLACE(DATE_SUB(NOW(), INTERVAL 1 month), "[ :\-]", "")
AND rc_timestamp > REGEXP_REPLACE(DATE_SUB(NOW(), INTERVAL 1 month), "[ :\-]", "")
AND (SELECT COUNT(rev_id) FROM revision JOIN page ON rev_page = page_id WHERE rev_user = user_id AND page_namespace = 0 LIMIT 50) = 50
AND rc_namespace = 0
GROUP BY user_id
HAVING COUNT(*) >= 5
ORDER BY user_editcount DESC;
SQL

Checking query status...
