New orphan finder (enwp)

SQL

# forked from 79084

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

COUNT(*)
#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 page_id not in (select cl_from from categorylinks where cl_to LIKE "Orphaned_%") # ADDED
#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 10;
SQL

Checking query status...
