Wikipedia:Most wanted stubs/How to update

From Wikipedia, the free encyclopedia

Contents 1 Oldest method 2 Topbanana method 3 Note 4 Triddle method

[edit] 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.

[edit] 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;

[edit] Note

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

[edit] 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.