New orphan finder (enwp)

SQL

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

SET @SEARCH_SPAN_DAYS = 7;

SET @ARTICLE_SPACE = 0;
#SET @EARLIEST_CREATION_DATE = DATE_ADD('20240405', INTERVAL -7 DAY);

SELECT page_title, page_id, SELECT DATE_ADD(CURRENT_DATE, INTERVAL -@DAYS_PER_WEEK DAY) as start_date
FROM page,revision
WHERE rev_page=page_id
and page_latest = rev_id
and rev_parent_id=0
and rev_timestamp > '20240401'
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_id not in (select cl_from from categorylinks where cl_to LIKE "Set_index%") # ADDED
and page_id not in (select cl_from from categorylinks where cl_to LIKE "Redirects%") # ADDED
and page_namespace = @ARTICLE_SPACE
and not page_is_redirect
order by page_title 
limit 1; # 04/01 (3 s), 03/25 (6 s); 03/20 (8 s); 03/15 (10 s); 03/10 (11 s); earlier dates may not complete
SQL

Checking query status...
