DBQ-187 Get all namespaces of all Wikipedias
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 4:10 PM

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-187.
Summary: Get all namespaces of all Wikipedias
Issue type: Task - A task that needs to be done.
Priority: Trivial
Status: Done
Assignee: Hoo man <hoo@online.de>

From: Avicennasis <Avicennasis@gmail.com>

Date: Wed, 20 Jun 2012 05:59:11

If possible, I'd like a list of all namespaces for all Wikipedias. Just the NS number is needed - i.e., 'NS:109' instead of 'NS:Book talk' on the English Wikipedia.

Version: unspecified
Severity: trivial

Details

Reference: bz59470

Event Timeline

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

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

• bzimport set Reference to bz59470.

JiraBugConverter created this task.Jan 3 2014, 4:10 PM

From: Hoo man <hoo@online.de>

Date: Sun, 24 Jun 2012 23:54:54

I've only scanned wikipedias, as you asked and only listed each namespace once.
SQL:

SELECT DISTINCT dbname, ns_id FROM namespacename WHERE domain LIKE "%wikipedia%" ORDER BY dbname, ns_id ASC;

Result:
http://toolserver.org/~hoo/dbq/dbq-187.txt

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: hoo@online.de
CC list: hoo@online.de, Avicennasis@gmail.com

Avicennasis subscribed.Jul 25 2015, 7:36 AM

DBQ-187 Get all namespaces of all WikipediasClosed, ResolvedPublicActions