SQL
AخA
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 '2015%'
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.