DBQ-17 Red links in en wikipedia containing a mismatched number of brackets
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:32 PM

Description

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.

Version: unspecified
Severity: trivial

Details

Reference: bz59273

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:19 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59273.

JiraBugConverter created this task.Jan 3 2014, 3:32 PM

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

DBQ-17 Red links in en wikipedia containing a mismatched number of bracketsClosed, ResolvedPublicActions

Description

Date: Thu, 27 Mar 2008 14:09:57

Details

Event Timeline

Date: Thu, 27 Mar 2008 14:39:15

Date: Thu, 27 Mar 2008 16:44:34

Date: Tue, 01 Apr 2008 07:15:49

DBQ-17 Red links in en wikipedia containing a mismatched number of brackets
Closed, ResolvedPublic
Actions