Orphan pages created by a user

SQL

set @usr:="Chaduvari";
SELECT 
 	page_title
-- 	actor_name, count(actor_name)
FROM
    page,revision,actor
  WHERE
    actor_id=rev_actor and
    rev_page=page_id and
    page_title not 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)>5
ORDER BY 
 page_title
-- count(actor_name) desc
SQL

Checking query status...
