Wikipedia talk:Most wanted stubs

Query

This page was generated with the following SQL query:

SELECT cur_title, COUNT(*) as numlinks 
FROM links, cur 
WHERE l_to=cur_id 
  AND cur_is_redirect = 0 
  AND cur_namespace=0 
  AND LENGTH(cur_text)<100 
GROUP BY cur_title 

ORDER BY numlinks DESC LIMIT 100

The query should be used sparingly as it puts a fairly high load on the server. (see Wikipedia:Database queries)

I will be regenerating the page every now and then according to demand. We can experiment with varying the size of article we look for - the present 100 character limit is very short. Enchanter 18:25 Aug 26, 2002 (PDT)

This page should pop up when Special Pages is selected. Ortolan88 18:31 Aug 26, 2002 (PDT)

Enchanter: Of course, now all of the articles on this page have one more "wanted" link, this page itself. When you regenerate, be sure to delete all the links from this page first, for a more accurate count!  :) DanKeshet

---

Expanded stubs

Turned The Scotsman into an article and removed it from the list. Palnu 03:53, 13 Jul 2004 (UTC)

---

I just did some work on Assiniboine River. Does it still count as a stub? If it doesn't then please remove the stub marker. Canadabear 22:01, 28 Feb 2004 (UTC)

Are we supposed to remove items if we expand them? I did a little more on New Haven, Connecticut and antipyretic. Vicki Rosenzweig 18:56 Aug 26, 2002 (PDT)

Yes, I think it might be a good idea to remove items, and I've changed the subject page to reflect that. It's not absolutely necessary, as the link would in any case automatically be removed when the page is regenerated. However, I think removing items from the list is a good marker of progress. It would also help to give this page lots of mentions in recent changes, which would help to attract more people to fix stubs. Enchanter

I think 'industry' can be removed now. cferrero

---

[X] This is a minor edit [ ] This is not a stub [X] Watch this article

Wonder if there would be an easier way for people to mark whether articles are stubs, than by writing it in the article...

Suppose can be hard to see what needs doing, since links to stub articles look like links to proper articles, rather than links to unwritten articles... كسيپ Cyp 21:44 Mar 7, 2003 (UTC)

Currently, you can set your set your preferences (Special:Preferences) to change the color of links to smaller articles ("Threshold for stub display", e.g. 100). -- User:Docu

Update list

I found Bhanja also under Music of India. It has a couple sentences down on the subject. What do I do in this situation? Canadabear

Would someone please re-run this to show current results? clarka 24 Aug 2003

Done Enchanter 22:22, 27 Aug 2003 (UTC)

I updated the list once more. Not all stubs have that many pages linking to them as listed and a few are disambiguation pages not formatted as such (currently John Nash, IRS). -- User:Docu

---

I tried to improve "Geographer". I'm rather new at this and not sure if I've done enough to de-stubify the page. Could someone confirm it and remove the stub text from the page? fvincent 17:00, Dec 1, 2003 (UTC)

There's no set limit on what counts as a stub. It depends a lot on whether you think enough is now covered in the article or whether it is still useful to have the stub notice. Personally, I think maybe more could be written but that it would be ok to remove the stub notice now. Up to you really. Good work on it by the way! Angela 19:34, 1 Dec 2003 (UTC)

Ok, I've removed the stub text because I don't think it's a stub anymore but I do agree it could be expanded quite a bit, hopefully by a geographer! fvincent 19:59, Dec 1, 2003 (UTC)

---

Perhaps it's time to recompile this page? Every three months sounds reasonable. fvincent 19:09, Dec 2, 2003 (UTC)

Three months does sound reasonable. Page now updated. Angela 00:27, 3 Dec 2003 (UTC)

This is three months out of date again, but I can't do anything about it now as sysop queries have been limited to 30 seconds, and the query needed to do this takes about four minutes. I've listed it on Wikipedia:SQL query requests so someone with a recent copy of the database can update it. Angela. 17:03, Mar 2, 2004 (UTC)

---

Albuquerque and other disambiguation pages shouldn't be here. 24.6.66.228

Feel free to remove them. The page isn't protected. Angela. 06:16, 31 Dec 2003 (UTC)

---

The updated list just added is mostly bogus--there's a bug that lists links from Orphaned articles a zillion times, so that by far the marjority of these have 0, or maybe 1 or 2, links to them in actuality. I started deleting those, but it looks like most of the list will then go away. Can someone generate something mo betta? Elf | Talk 04:38, 30 Mar 2004 (UTC)

The duplicate links to Orphaned articles is a known bug with the links table. You can request the query be re-run at Wikipedia:SQL query requests. See this version for an example. Angela. 23:19, Apr 1, 2004 (UTC)

Restocked the list

I have restocked the list with 100 items from a user report: User:Topbanana/Reports/This is one of the most linked to stubs. I'm working on getting a list of all most-wanted short articles, but until then this will do nicely. The drawbacks:

• Only four articles are actually less than 100 characters, as the page is supposed to be.
• Only pages with {{msg:stub}} are included, so unmarked stubs are still unseen.

Hopefully I (or someone wanting $10) will have a chance to run the original query. Between now and then, this list gives plenty of opportunities. Just as before, if you expand an article to the point that it is no longer a stub, remove the stub message and remove it from the list. Happy writing, --Ben Brockert 02:33, May 25, 2004 (UTC)

Do we remove them, or strike-them through? How long until we can get this updated again? Bo-Lingua 17:47, 8 Mar 2005 (UTC)

History Calls to Arms

I was intrigued by the fact that so many topics along the lines of: XXX BC had the same number of referenced links... Upon checking it out, this whole group needs to be considered a superstub of sorts. This is an worthy attempt to build a timeline of history along the lines of an almanac. If there is a 'wikiwide' communciation means, especially one that can be used to target history interested parties such as my humble self, I have a suggestion to clean this up expeditiously. Ask any and all members, for a two to three month genesis, to make an edit toward this worthy goal (entries are essentially 'bulleted single line items') inside the appropriate decade anytime they run across a dated historical event. After the genesis period, 'stub' can probably be safely removed from said articles -- some decades were (apparently <g>) boring so that little of historical note happened. This should shorten next years list significantly, assuming success in mobilizing the masses! A project like this needs publicity. High kudos to whomever concieved the idea! Fabartus 02:06, 30 May 2005 (UTC)

New data available

Hello,

Dmcdevit told me about this cleanup project. I have written my own software to generate a report for you which you can find at Wikipedia talk:Most wanted stubs/20050623-triddle. I would of integrated the new list into the page myself but I thought it would be best if a member of this project did it. Also sorry about the broken links; they should point at real articles but something is subtly wrong with the name. I'm not quite sure why that happens. Triddle 06:26, Jun 26, 2005 (UTC)

Merging new dataset myself

After checking the history of these project pages I've decided its likely that there is no one here to read this message or my previous one about the new data. I'm going to take it upon myself to replace the old list with my new one and list this page on the active cleanup projects template. Triddle 19:58, Jun 26, 2005 (UTC)