Orphan pages created by a user

SQL

set @usr:="Chaduvari";
SELECT 
	page_title,rev_timestamp
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_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...
