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;