User:JoeNMLC/Article orphan query


 * ⬆ Article cleanup

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.

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.

Query error and update
On 7 June 2024, Orphaned queries failed. See details here.
 * Here is the error query:
 * On above, the second "INNER JOIN" is replaced below with two "JOIN" statements.

Above changes are at Here you go. —Cryptic 21:15, 7 June 2024 (UTC)
 * Here is the updated query:

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:
 * 🟢 Football (soccer ball).svg – De-orphan footballer articles

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

Notes:
 * 1) Theater Istasyon - August 20, 2023