Tewiki:Orphan articles list with creator name

Fork of Tewiki:Orphan articles list with creator name by Chaduvari

This query is marked as a draft This query has been published by రవిచంద్ర.

SQL

SELECT page_title,actor_name
FROM page,actor,revision
WHERE actor_id=rev_actor
and rev_page=page_id
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")
and page_namespace = 0
and rev_parent_id=0
and page_is_redirect=0
and	actor_name= "రవిచంద్ర"
-- group by actor_name
order by rev_timestamp desc,actor_name desc

SQL

Checking query status...