Users >= 10 edits in 30 days to articles w/talk in cat, etc

Users who have at least 10 edits in the last 30 days to mainspace pages whose talk pages are categorized in [[Category:All WikiProject Medicine articles]], who aren't bots, aren't fully blocked (other than rangeblocks), are ips or have fewer than 10000 edits, and have at least 10% of their mainspace edits to such pages.

(30 days is, conveniently, as long as the recentchanges table lasts.)

For [[WP:RAQ#List of editors for a set of articles]] circa 13 January 2024.

SQL

SELECT actor_name, COUNT(*)
FROM recentchanges
JOIN page ON page_namespace = 1 AND page_title = rc_title
JOIN categorylinks ON cl_from = page_id
JOIN actor_recentchanges ON actor_id = rc_actor
WHERE rc_namespace = 0
  AND cl_to = 'WikiProject_Video_games_articles'
  AND rc_type IN (0, 1) -- edit of existing page, and new page - in particular, exclude Wikidata changes (5)
GROUP BY rc_actor
HAVING COUNT(*) >= 5
ORDER BY COUNT(*) DESC;

AخA
 
SELECT actor_name, COUNT(*)FROM recentchangesJOIN page ON page_namespace = 1 AND page_title = rc_titleJOIN categorylinks ON cl_from = page_idJOIN actor_recentchanges ON actor_id = rc_actorWHERE rc_namespace = 0  AND cl_to = 'WikiProject_Video_games_articles'  AND rc_type IN (0, 1) -- edit of existing page, and new page - in particular, exclude Wikidata changes (5)GROUP BY rc_actorHAVING COUNT(*) >= 5ORDER BY COUNT(*) DESC;

SQL

Checking query status...