On 10/15/07, Jun liu <junliug(a)yahoo.com> wrote:
Hi, I have downloaded the wikipedia database and want
to pose a query to search for all featured pages. Can
you tell me which table I should look into. Thank you
"Featured articles" have no formal status in the MediaWiki software.
There are, however, several ways you can find them from the article
metadata stored in the database.
For English Wikipedia you can look at the categorylinks table for
pages with the category "Wikipedia_featured_articles", although often
the talk page of the article is listed rather than the article itself.
It may be more reliable if you also look for pages which transclude
the template "featured_article" using the templatelinks table.