Replicas browser and optimizer
This query is marked as a draft
This query has been published
use arwiki_p; select actor_name, count(rev_id) from revision inner join actor on actor_id = rev_actor inner join page p1 on p1.page_id = rev_page where (select p2.page_id from page p2 where p2.page_title = p1.page_title and p2.page_namespace = (p1.page_namespace+1) and p2.page_is_redirect = 0) in (select cl_from from categorylinks where cl_to = "مقالات_مشروع_ويكي_طب") and p1.page_is_redirect = 0 and rev_timestamp like "2019%" group by actor_name order by count(rev_id) desc limit 500;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in