Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
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
.
Toggle Highlighting
SQL
# forked from 79084 SET @ARTICLE_SPACE = 0; SET @EARLIEST_TOUCH_DATE = '20240401'; SELECT COUNT(*) #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;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...