View source for Wiki143:Most wanted stubs/How to update

==Oldest method==

<pre>
#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
</pre>

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 [[User:Topbanana/Reports/Scripts/Create Link Analysis Database|Link Analysis Database]] using the SQL:

<pre><nowiki>
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;
</nowiki></pre>

==Note==

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

==[[User:Triddle|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 [[User Talk:Triddle|talk page]].
 
[[Category:Wikipedia maintenance|Stubs, most wanted]]
[[Category:Wikipedia tools|Stubs, most wanted]]