Top contributors in WP:MED articles in 2021 (en wiki)

Excludes bots by removing users with bot in the title.... can use user usergroups instead, see https://wikitech.wikimedia.org/wiki/Help:MySQL_queries/Example_queries (though those queries are all currently broken)

SQL

SELECT actor_name, count(*) from revision 
WHERE lower(actor_name) NOT LIKE '%bot%'
  join actor on rev_actor = actor_id 
  join page on rev_page = page_id 
    WHERE page_namespace = 0 AND rev_timestamp like '2021%' and page_title in (SELECT page_title FROM (
  SELECT tl_from, rd_from
  FROM `templatelinks`
  	LEFT JOIN `redirect`
  		ON ((rd_from = tl_from) AND rd_title = 'WikiProject_Medicine' AND (rd_interwiki = '' OR rd_interwiki IS NULL) AND rd_namespace = '10')
  	INNER JOIN `page`
  		ON ((tl_from = page_id))
  WHERE
  	tl_namespace = '10' AND
  	tl_title = 'WikiProject_Medicine'
  ORDER BY tl_from) `temp_backlink_range` INNER JOIN `page` ON ((tl_from = page_id)) WHERE page_namespace = '1') group by actor_id order by count(*) desc limit 500;

SQL

Checking query status...