Welcome to the MedLibrary.org Wikipedia Supplement on Wikipedia:Most wanted stubs/How to update -- Please Click to Return to Front Page

Oldest method

#Use at your own risk, no warranty implied or given.
#Please help debug and improve the query.

SELECT 
    CONCAT('# ([[Special:Whatlinkshere/', s_title, '|links: '),
    Count(DISTINCT l_from) AS numlinks,
    CONCAT(']]) -- [[', 
                    REPLACE(s_title,'_',' '), 
                    ']]  (', 
                    s_size, 
                    ' bytes)') AS list 
INTO OUTFILE 'wp_Most_wanted_stubs.txt'
FROM temp_sizesmall, temp_deorphan
WHERE s_id=l_to
GROUP BY s_id
ORDER BY numlinks DESC, s_title
LIMIT 250

The temp_deorphan table is created with Wikipedia:Orphaned Articles/How to update. The temp_sizesmall table is also used at Wikipedia:Shortpages/How to update.

Topbanana method

This report is generated from a Link Analysis Database using the SQL:

select concat( '#[[', art_title, ']] (', links_to, ' articles)' )
from art
where art.art_is_redirect = 0
and art.art_is_stub = 1
and art.art_is_disambig = 0
order by links_to desc
limit 200;

Note

The above queries may need to be improved so that only articles under Category:Stub categories are listed.

Triddle method

I've placed a list on this project page that was generated with perl. It scans a dump of the cur table then scans a dump of the links table to generate the list; this takes about 10 minutes. If you would like more information just drop a note on my talk page.

Wikipedia content modification information:

• This page was last modified on 6 February 2007, at 22:52.

Wikipedia Authorship and Review

Wikipedia content provided here is not reviewed directly by MedLibrary.org. Wikipedia content is authored by an open community of volunteers and is not produced by or in any way affiliated with MedLibrary.org.

Wikipedia Usage Guidelines

This article is licensed under the GNU Free Documentation License. It uses material from the Wikipedia article on "Wikipedia:Most wanted stubs/How to update".

The URL for this specific entry is:

• http://medlibrary.org/medwiki/Wikipedia:Most_wanted_stubs/How_to_update

All Wikipedia text is available under the terms of the GNU Free Documentation License. (See Copyrights for details). Wikipedia® is a registered trademark of the Wikimedia Foundation, Inc.