Toolserver:Query service

Often, people on Wikimedia projects have a question they can't get an answer to from MediaWiki, but which can be easily answered by asking the database directly. The query service aims to help Wikimedians get the answers they need. It's simple:


 * If you want someone to run a SQL query for you, please file a request on DBQ
 * Note: Filing a request on JIRA requires creating an account and logging in.
 * After doing so, go to https://jira.toolserver.org/browse/DBQ and select "Create new issue"; then select "Next>>"
 * Please be as detailed as possible about what data you need, in what order, in what format
 * If you can, provide the SQL query
 * If you are a Toolserver user and are willing to run a query every now and then, please look at DBQ and take whatever task you like.
 * Before running the query, make sure it's feasible. EXPLAIN the query first.
 * Please consider using batch job scheduling for your query.
 * Post the result as a plain file on the Toolserver, or to a wiki page, if that was requested
 * Please record the exact query you used for future reference, ideally in a comment to the JIRA ticket.

Note: we now have the report tool as well; if you expect to need this query more than once, you can request it be added to the tool, where it will be updated automatically.

If you are interested in handling requests for database queries regularly, ask a root to assign you to the DBQ JIRA group. You will then be notified of any new requests for queries filed in JIRA. You can also create a JIRA filter (using 'find issues'), to find new queries in this project, and mail them to you periodically, or produce an RSS feed.

The person who runs the database query will add it to the wiki (below) if necessary.

Past JIRA requests
''Note: Only the person running the query should add it to this list. If you want to request a new query, file a request DBQ on JIRA.''