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
- Examples: association football biographies
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.
Query error and update
[edit]On 7 June 2024, Orphaned queries failed. See details here.
- Here is the error query:
USE enwiki_p;
SELECT p.page_title
FROM page p
INNER JOIN categorylinks c ON p.page_id = c.cl_from AND c.cl_to = "Orphaned_articles_from_June_2024"
INNER JOIN pagelinks pl ON p.page_title = pl.pl_title AND p.page_namespace = pl.pl_namespace
INNER JOIN page p2 ON p2.page_id = pl.pl_from
AND pl.pl_from_namespace = 0 and p2.page_is_redirect=0
GROUP BY p.page_title
having COUNT(pl.pl_from)>1
ORDER BY COUNT(pl.pl_from) desc, p.page_title;
- On above, the second "INNER JOIN" is replaced below with two "JOIN" statements.
- Here is the updated query:
USE enwiki_p; SELECT p.page_title FROM page p INNER JOIN categorylinks c ON p.page_id = c.cl_from AND c.cl_to = "Orphaned_articles_from_June_2024" JOIN linktarget ON p.page_title = lt_title AND p.page_namespace = lt_namespace JOIN pagelinks pl ON lt_id = pl_target_id INNER JOIN page p2 ON p2.page_id = pl.pl_from AND pl.pl_from_namespace = 0 and p2.page_is_redirect=0 GROUP BY p.page_title having COUNT(pl.pl_from)>1 ORDER BY COUNT(pl.pl_from) desc, p.page_title;
Above changes are at Here you go. —Cryptic 21:15, 7 June 2024 (UTC)
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]2018 Orphan archive
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2019
[edit]2019 Orphan archive
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2020
[edit]2021
[edit]Category | Query date | Before count | After count | Reduction |
---|---|---|---|---|
Category here | Query date | B= | A= | R= |
Orphaned_articles_from_January_2021 | D 🔷 🟡 |
B 🟡 |
A 🟡 |
R 🟡 |
Orphaned_articles_from_February_2021 | D 🔷 | B | A | R |
Orphaned_articles_from_March_2021 | D 🔷 | B | A | R |
Orphaned_articles_from_April_2021 | D 🔷 | B | A | R |
Orphaned_articles_from_May_2021 | D 🔷 | B | A | R |
Orphaned_articles_from_June_2021 | D 🔷 | B | A | R |
Orphaned_articles_from_July_2021 | D 🔷 | B | A | R |
Orphaned_articles_from_August_2021 | D 🔷 | B | A | R |
Orphaned_articles_from_September_2021 | D 🔷 | B | A | R |
Orphaned_articles_from_October_2021 | D 🔷 | B | A | R |
Orphaned_articles_from_November_2021 | D 🔷 | B | A | R |
Orphaned_articles_from_December_2021 | D 🔶 | B | A | R |
Category here | Query date | B= | A= | R= |
2022
[edit]Category | Query date | Before count | After count | Reduction |
---|---|---|---|---|
Category here | Query date | B= | A= | R= |
Orphaned_articles_from_January_2022 | D 🔷 🟡 |
B 🟡 |
A 🟡 |
R 🟡 |
Orphaned_articles_from_February_2022 | D 🔷 | B | A | R |
Orphaned_articles_from_March_2022 | D 🔷 | B | A | R |
Orphaned_articles_from_April_2022 | D 🔷 | B | A | R |
Orphaned_articles_from_May_2022 | D 🔷 | B | A | R |
Orphaned_articles_from_June_2022 | D 🔷 | B | A | R |
Orphaned_articles_from_July_2022 | D 🔷 | B | A | R |
Orphaned_articles_from_August_2022 | D 🔷 | B | A | R |
Orphaned_articles_from_September_2022 | D 🔷 | B | A | R |
Orphaned_articles_from_October_2022 | D 🔷 | B | A | R |
Orphaned_articles_from_November_2022 | D 🔷 | B | A | R |
Orphaned_articles_from_December_2022 | 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