Untitled query #78732

SQL

SELECT user_name as Editor, page_title as '94rain', count(*) as AfCedits
FROM revision_userindex
JOIN actor ON rev_actor = actor_id
JOIN comment_revision ON comment_id = rev_comment_id
JOIN page ON rev_page = page_id
JOIN user ON actor_user = user_id
WHERE
-- actor_name = user_name -- spaces AND
page_title != REPLACE(user_name, ' ', '_') -- underscores
AND page_namespace = 3 -- user talk
AND comment_text RLIKE '(?:accepted|declined|rejected)'
    AND rev_timestamp > date_add(now(), interval -1 day)
--    and user_editcount > 1000
-- AND NOT EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'sysop') -- administrator
-- AND NOT EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'patroller') -- new page patroller
-- AND NOT EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'bot') -- new page patroller
    group by user_id
--    having AfCedits > 35
    order by AfCedits desc;
SQL

Checking query status...
