Orphan pages created by a user

SQL

set @usr:="Muralikrishna_m";
SELECT 
	page_title
FROM
    page
  WHERE
--    actor_id=rev_actor and
--    rev_page=page_id and
    page_title in (select pl_title from pagelinks where pl_namespace=0 and pl_from_namespace=0) and
    page_id not in (select pp_page from page_props where pp_propname="disambiguation") and
    page_id in (select cl_from from categorylinks where cl_to ="అనాథ_పేజీలు") and
    page_namespace = 0 and
--    rev_parent_id=0 and
    page_is_redirect=0 -- and
-- 	actor_name= @usr
--    rev_timestamp like "202204%"
-- group by actor_name
-- having count(actor_name)>4
-- ORDER BY rev_timestamp desc
SQL

Checking query status...
