Enwiki pages corresponding to Tewiki Orphans

SQL

SELECT concat("[[:en:",ll_title,"]]")
FROM page,actor,revision,langlinks
WHERE actor_id=rev_actor
and rev_page=page_id
and ll_from=page_id
and ll_lang="en"
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= "Chaduvari"
-- group by actor_name
order by rev_timestamp desc

SQL

Checking query status...