USE enwiki_p;

SELECT CONCAT('User:', rev_user_text), count(*) AS numedits

FROM revision_userindex r

JOIN page p

ON r.rev_page=p.page_id

LEFT JOIN (SELECT * FROM user_groups WHERE ug_group='bot') ug

ON r.rev_user=ug.ug_user

WHERE r.rev_user > 0

AND r.rev_timestamp > '20170101000000'

AND p.page_namespace IN (4,5)

AND p.page_title LIKE 'WikiProject%'

AND ug.ug_group IS NULL

GROUP BY r.rev_user

ORDER BY count(*) DESC

LIMIT 100;