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

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)