Untitled query #28412

SQL

use hywiki_p;
select rev_user_text, count(*), sum(rev_len) 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' )
) and rev_user_text not like '%Bot' COLLATE utf8_general_ci
group by rev_user_text
order by 3 desc;
SQL

Checking query status...
