Top contributors in WP:MED articles in 2023 (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 
join actor on rev_actor = actor_id 
join page on rev_page = page_id
WHERE lower(cast(actor_name as CHAR)) NOT LIKE '%bot%' AND page_namespace = 0 AND rev_timestamp like '2023%'
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))
  	JOIN `linktarget`
  		ON ((tl_target_id = lt_id))
  WHERE
  	lt_namespace = '10' AND
  	lt_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 510;

SQL

Checking query status...