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 rev_user_text, rev_timestamp, COUNT(rev_id)
FROM user_groups JOIN revision_userindex ON ug_user = rev_user
JOIN user ON ug_user = user_id
WHERE user_registration > 20180901000000
AND 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')
AND rev_timestamp > 20181201000000                      
GROUP BY rev_user 
ORDER BY COUNT(*) DESC
LIMIT 1000;
SQL

Checking query status...
