contribs after a year

SQL

#SELECT rev_user_text, COUNT(rev_id) 
#FROM revision_userindex 
#WHERE rev_timestamp > (NOW() - INTERVAL 1 DAY)
#GROUP BY rev_user 
#ORDER BY COUNT(*) DESC;


SELECT ug_user FROM user_groups
WHERE ug_group NOT IN ('abusefilter', 'abusefilter-helper', 'accountcreator', 'autoreviewer', 'bot', 
                       'bureaucrat', 'checkuser', 
                       #'confirmed', 
                       'copyviobot','epadmin', 'eventcoordinator', 'extendedconfirmed', 'extendedmover', 
                       'filemover', 'flow-bot', 'founder', 'import', 'interface-admin', 'ipblock-exempt', 
                       'massmessage-sender','oversight', 'patroller', 'researcher', 'reviewer', 
                       'rollbacker', 'sysop', 'templateeditor')
LIMIT 10;
SQL

Checking query status...
