Wikipedia talk:Most wanted stubs: Difference between revisions

Content deleted Content added

Inline

Revision as of 18:35, 26 August 2002

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.

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

@@ Line 8: / Line 8: @@
    AND LENGTH(cur_text)<100
  GROUP BY cur_title
  ORDER BY numlinks DESC LIMIT 100
@@ Line 13: / Line 15: @@
 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. [[User:Enchanter|Enchanter]] 18:25 Aug 26, 2002 (PDT)
 :This page should pop up when Special Pages is selected.  [[User:Ortolan88|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!  :) [[User:DanKeshet|DanKeshet]]