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

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

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)