Tewiki:orphan articles count creator wise

SQL

SELECT actor_name,count(actor_name) from page, actor, revision

WHERE page_id=rev_page
and actor_id=rev_actor
-- and rev_timestamp >="20240101000000"
-- and rev_timestamp <"20240401000000"
and rev_parent_id=0
and page_namespace=0
and page_is_redirect=0
and page_title not in (select lt_title from pagelinks, linktarget where pl_target_id=lt_id and lt_namespace=0 and pl_from_namespace=0)
and page_id not in (select pp_page from page_props where pp_propname="disambiguation")
group by actor_name
order by count(actor_name) desc

SQL

Checking query status...