Medicine in hywiki

This is people with most edits to articles in [[Category:Բժշկություն]] on hywiki, and any of its subcategories (to depth 2)

SQL

use hywiki_p;
select rev_user_text, count(*) from categorylinks inner join revision_userindex on rev_page = cl_from
where (
  cl_to = 'Բժշկություն'
  OR
  cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = 'Բժշկություն' and cl_type = 'subcat' )
  OR
  cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = 'Բժշկություն' and cl_type = 'subcat' ) and cl_type = 'subcat' )
)
group by rev_user_text
order by 2 desc;

SQL

Checking query status...