Wikipedia:Database queries: Difference between revisions

Revision as of 08:58, 18 January 2014

Revision as of 10:26, 18 January 2014

Line 5:

== Overview ==

Much of the data that makes up the Wikipedia encyclopaedia is stored in a [[SQL database]]. It can sometimes be useful to run queries against this database to extract information that is otherwise hard to find. For example:

* Articles with ''H.M.S.'' in their title that have not been edited for 12 months.

* [[WP:Redirect|Redirects]] with fewer than 20 incoming links that redirect to [[WP:Category|categories]]

* All [[WP:Red tube link|red links]] on pages within the scope of a particular [[WP:WikiProject|WikiProject]]

Many simple queries can be run directly using the tools built into the [[MediaWiki]] package used by Wikipedia. Some of the most popular and useful queries are run regularly and can be found at [[Wikipedia:Database reports]]. If neither of these suits your query, you can request that someone run a query for you, or download your own copy of the database to work on.