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 = '20240325';

SELECT COUNT(*) #page_title
FROM page,revision
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 page_namespace = @ARTICLE_SPACE
and rev_parent_id=0
and page_is_redirect=0
order by page_title desc
#limit 10; # 10 for 04/01+

SQL

Checking query status...