Wikipedia:Database queries: Difference between revisions

Revision as of 12:25, 29 August 2014

Latest revision as of 06:48, 22 May 2023

(16 intermediate revisions by 13 users not shown)

Line 1:

{{nutshell

{{shortcut|WP:SQL}}

|shortcut1=WP:DQ

|shortcut2=WP:SQL

{{nutshell|Queries can be run against the Wikipedia database in a variety of ways.}}

== Overview ==

Much of the data that makes up the Wikipedia encyclopaediaencyclopedia 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.

Line 11 ⟶ 12:

* All [[WP:Red 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 [[Wikipedia:Request a query|request]] that someone run a query for you, or download your own copy of the database to work on.

== Using the MediaWiki tools ==

Line 30 ⟶ 31:

And many other places.

== Requesting thatRun a query be run ==

SomeAll Wikipedians have the ability to run queries on a copy of the live database on the [[WP:Wikimedia LabsCloud Services|Wikimedia LabsCloud VPS]]. You may request they do this atcalled [//quarry.wmflabs.org/ Quarry].

== Request a query ==

* [[Wikipedia:Request a query]]

== See also ==

*[[wikitech:Nova Resource:Tools/Tools/Query service]]