New orphan finder (enwp)

Fork of Tewiki:Orphan pages list with creator name by Tester.eban.t

This query is marked as a draft This query has been published by Bri.

SQL

# forked from 79084

SET @ARTICLE_SPACE = 0;
SET @EARLIEST_TOUCH_DATE = '20240401';

SELECT page_title
FROM page,revision#,categorylinks as c
WHERE rev_page=page_id
and page_latest = rev_id
and rev_timestamp > @EARLIEST_TOUCH_DATE
and page_title not in (select pl_title from pagelinks where pl_namespace=@ARTICLE_SPACE and pl_from_namespace=@ARTICLE_SPACE)
and page_id not in (select pp_page from page_props where pp_propname="disambiguation")
#and not (page_id = c.cl_from and c.cl_to LIKE "Orphaned_%") # ADDED
and page_namespace = @ARTICLE_SPACE
and rev_parent_id=0
and page_is_redirect=0
order by page_title desc
limit 1;

SQL

Checking query status...