Tewiki: AP village pages in WPWPTE

SQL

set @area:="ఆంధ్రప్రదేశ్_గ్రామాలు";
select page_title from revision,comment,page 
where comment_id=rev_comment_id 
                  and page_id=rev_page
                  and page_namespace=0
and comment_text like "%WPWPTE%"
and page_id in (select cl_from from categorylinks where (cl_to = @area
  			OR
  				cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = @area 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 = @area 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 = @area and cl_type = 'subcat' ) and cl_type = 'subcat' ) and cl_type = 'subcat' )
                                                         ))
and rev_timestamp>="2021080300000"
and rev_timestamp<"2021081000000"

order by page_title
SQL

Checking query status...
