USE wikidatawiki_p;

SELECT actor_name, COUNT(rev_id) AS c FROM pagelinks

JOIN revision_userindex ON rev_page = pl_from

JOIN actor_revision ON rev_actor = actor_id

WHERE pl_title = 'Q214' # parameter

AND pl_namespace = 0 AND pl_from_namespace = 0

AND actor_user IS NOT NULL

AND actor_user NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bot')

AND rev_timestamp > '2021' # parameter

GROUP BY rev_actor

HAVING c > 500 # parameter

ORDER BY c DESC;