Wikipedia:Most wanted stubs/How to update

Oldest method

 * 1) Use at your own risk, no warranty implied or given.
 * 2) Please help debug and improve the query.

SELECT CONCAT('# (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 Orphaned Articles/How to update. The temp_sizesmall table is also used at 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.