⬆ Article cleanup

Below are the pages for article cleanup tasks.

Update this page

Orphan query

Orphaned articles with more than two incoming links

The following is an edited excerpt from WP Talk - Orphan - Orphaned articles from July 2023 discussion. August 3, 2023.

On a aside-note, it seems like we've all found the same quarry - I use to run this quarry ( 9081 ) to find de-orphaned articles that can be de-tagged,
which I forked/copied from this quarry ( 6731 ) by GoingBatty
- just want to give cred. Jonatan Svensson Glad (talk) 20:10, 16 August 2023 (UTC)

@JoeNMLC Been a while since I am here. I just ran a similar query script ( 39296 ) as this DB report to detect more than 0 incoming link for Orphaned articles from July 2023... Justanothersgwikieditor

@JoeNMLC I have another query ( 38614 ) which list all the orphans but for your specific case, click the fork button on the top right so you will create a new query for yourself, change "Orphaned_articles_from_July_2023" to "Orphaned_articles_from_MONTH_YYYY" and then click "Submit Query" button. The "Orphaned_articles_from_MONTH_YYYY" format needs to follow the same "Orphaned articles from July 2023" similar to the category name (aka full month July, September instead of just Jul or Sep). Please note the query needs the underscore as it do not understand blank spaces.Justanothersgwikieditor

For the list of orphan articles to de-tag, run Query #38614, link below.

• Untitled query #38614 - Quarry
  • Research:Quarry - Meta

Query instructions

Instructions to obtain a list of currently tagged orphan articles:

1. Start query script tool.
2. Click on "Fork" button, for first few times. After several requests, just click Log in.
3. It should auto-login, otherwise Log in, and next time it should remember.
4. Click on Home and select a recent request.
5. Change category to query, for example: "Orphaned_articles_from_August_2023"
   Note the underscores are required.
   At line having COUNT(pl.pl_from)>1, leave at 1 for first pass;
   Change from "1" to zero for second pass.
6. Click on "Submit Query" button.
7. From results list, copy/paste into any plain text editor.
8. Update the wikitable below, with "Before count" of articles in category.
9. From the query article list, most articles can have orphan tag removed. A few may be disambig articles, so check every article "What links here" (ctrl-alt-j) to verify before removing the orphan tag.
10. When done un-tagging orphan articles, enter "After count" of articles in category,
    and the "Reduction" number.

Progress

Below are wikitables for progress tracking.

Legend for "Before count" column:

>1 – Articles with 2 or more incoming wikilinks

>0 – Articles with 1 or more incoming wikilinks

Legend for "Reduction" column:

🟢 – De-orphan footballer articles

2014

2015

2016

2017

Category Tracking of Articles Un-tagged

Category	Query date	Before count	After count	Reduction
Category here	Query date	B=	A=	R=
Orphaned_articles_from_January_2017	Dec.18, 2023 Dec. 27-28	1,087 (Q=108) >1 985 (Q=309) >0	985 760	102 225
Orphaned_articles_from_February_2017	Jan. 2, 2024 Jan. 2-3	1,041 (Q=88) >1 959 (Q=302) >0	959 793	82 166
Orphaned_articles_from_March_2017	Jan. 5 Jan. 5-6,8-9	1,147 (Q=120) >1 1,037 (Q=405) >0	1,037 782	110 255
Orphaned_articles_from_April_2017	Jan. 10 Jan. 11-12	672 (Q=126) >1 553 (Q=233) >0	553 387	119 166
Orphaned_articles_from_May_2017	Jan. 22 Jan. 22-23	723 (Q=53) >1 677 (Q=225) >0	677 553	46 124 🟢
Orphaned_articles_from_June_2017	Jan. 24 Jan. 24-25	643 (Q=46) >1 604 (Q=158) >0	604 510	39 94
Orphaned_articles_from_July_2017	Jan. 25 Jan. 26	277 (Q=27) >1 255 (Q=98) >0	255 188	22 67
Orphaned_articles_from_August_2017	Feb. 1 Feb. 2-3	610 Q=(72) >1 546 (Q=182) >0	546 437	64 109
Orphaned_articles_from_September_2017	Feb. 6 Feb. 7-8	507 (Q=50) >1 461 (Q=152) >0	461 366	46 95
Orphaned_articles_from_October_2017	Feb. 9 Feb. - 🔷	464 (Q=44) >1 423 (Q=161) >0	423 - 🟡	41 - 🟡
Orphaned_articles_from_November_2017	D 🔷	B - 🟡	A - 🟡	R - 🟡
Orphaned_articles_from_December_2017	D 🔶	B	A	R
Category here	Query date	B=	A=	R=

2018

Orphan help

Example, asking for help with orphan article.

== Article help ==

Greetings @[[articleCreator]], This one sentence article that was created 30 November 2011‎ remains an Orphan and needs to be expanded from the current size of 749 bytes. Instead of "Proposing for deletion", I am asking for your help here. Regards,

1. Place on Article's Talk page
2. Add to my Watchlist
3. Place Notice on Article page

((Notice|See [[Talk: articleName ]], please expand this article, created in 2011.))

Notes:

1. Theater Istasyon - August 20, 2023