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 jira:DBQ
- Note: Filing a request on JIRA requires creating an account and logging in.
- After doing so, go to https://jira.ts.wikimedia.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 jira:DBQ and take whatever task you like.
- Before running the query, make sure it's feasible. EXPLAIN the query first.
- 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.
If you are interested in handling requests for database queries regularly, visit Special:Userrights and add yourself to the query-service 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.
[edit] Currently active queries
- Only the person running the query should add it to this list. If you want to request a new query, file a request on JIRA.
[edit] Begriffsklärungsseiten
[edit] WantedTemplates cswiki
[edit] Image hash collisions
[edit] short pages enwiki
[edit] unused templates enwiki
[edit] Temporary Wikipedian userpages
[edit] long audio files on commons
[edit] broken image links
[edit] broken template uses