New orphan finder (enwp)

SQL

# forked from 79084
# pages that were orphans when created
# filtered by creation date

SET @ARTICLE_SPACE = 0;
SET @EARLIEST_CREATION_DATE = '20240308';

SELECT page_title, page_id
FROM page,revision
WHERE rev_page=page_id
and page_latest = rev_id
and rev_parent_id=0
and rev_timestamp > @EARLIEST_CREATION_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 page_id not in (select cl_from from categorylinks where cl_to LIKE "Orphaned_%") # ADDED
and page_id not in (select cl_from from categorylinks where cl_to LIKE "Surnames") # ADDED
and page_id not in (select cl_from from categorylinks where cl_to LIKE "Given_names") # ADDED
and page_namespace = @ARTICLE_SPACE
and page_is_redirect=0
order by page_title 
limit 100; # 10 for 04/01+, 19 for 03/25 (6 s); 36 for 03/20 (8 s); 46 for 03/15 (10 s); 03/10 (11 s)
SQL

Checking query status...
