Tewiki India Disrict HQ article creators

SQL

select actor_name,count(actor_name) from page,revision,actor
where page_id in (select cl_from from categorylinks 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' )
                                                          ))
and page_namespace=0
and rev_page=page_id
and actor_id=rev_actor
and rev_parent_id=0
group by actor_name
order by count(actor_name) desc
SQL

Checking query status...
