Orphan pages created by a user

SQL

set @usr:="Chaduvari";
SELECT 
    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 in (select cl_from from categorylinks where cl_to ="అన్ని_అనాథ_పేజీలు") and
    page_namespace = 0 and
    rev_parent_id=0 and
    page_is_redirect=0
--    actor_name= @usr
--    rev_timestamp like "202204%"
group by actor_name
having count(actor_name)>5
ORDER BY 
count(actor_name) desc
SQL

Checking query status...
