Last modified: 2014-01-03 15:32:53 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-17. Summary: Red links in en wikipedia containing a mismatched number of brackets Issue type: Task - A task that needs to be done. Priority: Trivial Status: Done Assignee: Topbanana <wikipedia@tiko.demon.co.uk> ------------------------------------------------------------------------------- From: Topbanana <wikipedia@tiko.demon.co.uk> Date: Thu, 27 Mar 2008 14:09:57 ------------------------------------------------------------------------------- Just a simple test query to see how this service works. I'd like a listing of all red links in the main namespace of the en wikipedia containing a mismatched number of brackets - for example "[[fred (artist]]". Handy SQL trick for this is WHERE length(replace(linktext, '(', '')) <> length(replace(linktext, ')', '')). Ideally I'd like to be made a toolserver user and run the query myself.
------------------------------------------------------------------------------- From: Daniel Kinzler <daniel@brightbyte.de> Date: Thu, 27 Mar 2008 14:39:15 ------------------------------------------------------------------------------- i don't this this is feasable - "string magic" queries are generally evil, and this one would be run against about 10 million red links (iirc) on enwiki.
------------------------------------------------------------------------------- From: Topbanana <wikipedia@tiko.demon.co.uk> Date: Thu, 27 Mar 2008 16:44:34 ------------------------------------------------------------------------------- No problem - pop a LIMIT 100 on the query or just return results for article id's less than 10000 if it's a concern. To date I've been downloading the periodic database dumps onto a cranky old server box to run queries like this - I'm more interested in finding out how this service works and what it's capable of for now. If I can get (or do) arbitrary queries (within reason) against a reasonably up to date wikipedia database from this service I'll be a very happy bunny indeed ![][1] [1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif
------------------------------------------------------------------------------- From: Topbanana <wikipedia@tiko.demon.co.uk> Date: Tue, 01 Apr 2008 07:15:49 ------------------------------------------------------------------------------- Okay, request withdrawn.
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: wikipedia@tiko.demon.co.uk CC list: wikipedia@tiko.demon.co.uk, daniel.kinzler@wikimedia.de