select actor_name,count(rev_actor) as countt from revision,comment,actor,page 

where comment_id=rev_comment_id 

                  and rev_actor=actor_id

                  and page_id=rev_page

and comment_text like "%WPWPTE%"

and 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' )

            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' )

            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 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 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 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 cl_type = 'subcat' )

           ))                                                

group by rev_actor

order by count(rev_actor) desc