Untitled query #31428

SQL

USE trwiki_p;
SELECT (SELECT user_name from user where user_id=revision.rev_user) as UserName , COUNT(*) as countrecent
FROM revision
INNER JOIN page 
 ON (page.page_id=revision.rev_page)
  AND (page.page_namespace = 0)
  AND (page.page_is_redirect = 0)
  AND (revision.rev_user > 0)
  AND  revision.rev_timestamp > DATE_SUB(NOW(),INTERVAL 7 DAY) 
WHERE not exists ( select ug_user from user_groups where ug_group='bot' and ug_user=rev_user)  
GROUP BY revision.rev_user
HAVING count(*)>4 -- users with gt 4 edits in last days
ORDER BY 2 DESC
SQL

Checking query status...
