Tewiki: user-wise WPWPTE to village pages

SQL

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 rev_timestamp>="2022070100000"
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' )
                                                         ))

group by rev_actor
order by count(rev_actor) desc
SQL

Checking query status...
