User:JoeNMLC/Article orphan query
Below are the pages for article cleanup tasks. |
- Find short articles
- Article tracking
- De-orphan list
- Helpful guidance
- Tracking many categories
- Article orphan tutorial (new)
- Tutorial with examples
Orphan query[edit]
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.
Query instructions[edit]
Instructions to obtain a list of currently tagged orphan articles:
- Start query script tool.
- Click on "Fork" button, for first few times. After several requests, just click Log in.
- It should auto-login, otherwise Log in, and next time it should remember.
- Click on Home and select a recent request.
- 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. - Click on "Submit Query" button.
- From results list, copy/paste into any plain text editor.
- Update the wikitable below, with "Before count" of articles in category.
- 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.
- When done un-tagging orphan articles, enter "After count" of articles in category,
and the "Reduction" number.
Progress[edit]
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:
2014[edit]
2014 Orphan archive
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2015[edit]
2015 Orphan archive
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2016[edit]
2016 Orphan archive
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2017[edit]
2017 Orphan archive
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2018[edit]
Category | Query date | Before count | After count | Reduction |
---|---|---|---|---|
Category here | Query date | B= | A= | R= |
Orphaned_articles_from_January_2018 | Feb. 27, 2024 Feb. 28 |
321 (Q=35) >1 287 (Q=87) >0 |
287 226 |
34 61 |
Orphaned_articles_from_February_2018 | March 1 March 2,4 |
554 (Q=61) >1 496 (Q=149) >0 |
496 404 |
58 92 |
Orphaned_articles_from_March_2018 | March 4 March 4-5 |
594 (Q=64) >1 535 (Q=215) >0 |
535 374 |
59 161 |
Orphaned_articles_from_April_2018 | March 5 March 5 |
231 (Q=37) >1 196 (Q=60) >0 |
196 160 |
35 36 |
Orphaned_articles_from_May_2018 | March 5 March 5 |
164 (Q=23) >1 142 (Q=47) >0 |
142 125 |
22 17 |
Orphaned_articles_from_June_2018 | March 5 March 6-7 |
785 (Q=35) >1 754 (Q=215) >0 |
754 614 |
31 140 |
Orphaned_articles_from_July_2018 | March 7 March 7 |
256 (Q=28) >1 232 (Q=83) >0 |
232 177 |
24 55 |
Orphaned_articles_from_August_2018 | March 11 March 11 |
315 (Q=37) >1 279 (Q=89) >0 |
279 222 |
36 57 |
Orphaned_articles_from_September_2018 | March 11 March 12 |
779 (Q=66) >1 720 (Q=230) >0 |
720 588 |
59 182 |
Orphaned_articles_from_October_2018 | March 13 March 13 |
389 Q=(36) >1 359 (Q=135) >0 |
359 277 |
30 82 |
Orphaned_articles_from_November_2018 | March 14 March 14 |
245 (Q=31) >1 217 (Q=73) >0 |
217 179 |
28 38 |
Orphaned_articles_from_December_2018 | March 14 March 14-15 |
688 (Q=59) >1 641 (Q=177) >0 |
641 554 |
47 87 |
Category here | Query date | B=5,321 | A=3,900 | R=1,421 |
2019[edit]
2020[edit]
Category | Query date | Before count | After count | Reduction |
---|---|---|---|---|
Category here | Query date | B= | A= | R= |
Orphaned_articles_from_January_2020 | D 🔷 🟡 |
B 🟡 |
A 🟡 |
R 🟡 |
Orphaned_articles_from_February_2020 | D 🔷 | B | A | R |
Orphaned_articles_from_March_2020 | D 🔷 | B | A | R |
Orphaned_articles_from_April_2020 | D 🔷 | B | A | R |
Orphaned_articles_from_May_2020 | D 🔷 | B | A | R |
Orphaned_articles_from_June_2020 | D 🔷 | B | A | R |
Orphaned_articles_from_July_2020 | D 🔷 | B | A | R |
Orphaned_articles_from_August_2020 | D 🔷 | B | A | R |
Orphaned_articles_from_September_2020 | D 🔷 | B | A | R |
Orphaned_articles_from_October_2020 | D 🔷 | B | A | R |
Orphaned_articles_from_November_2020 | D 🔷 | B | A | R |
Orphaned_articles_from_December_2020 | D 🔶 | B | A | R |
Category here | Query date | B= | A= | R= |
Orphan help[edit]
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,
- Place on Article's Talk page
- Add to my Watchlist
- Place Notice on Article page
- {{Notice|See [[Talk: articleName ]], please expand this article, created in 2011.}}
Notes:
- Theater Istasyon - August 20, 2023