Tewiki: India districts 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 page_title like "%జిల్లా"
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...
