Last modified: 2014-01-03 16:10:56 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T61470, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 59470 - DBQ-187 Get all namespaces of all Wikipedias
DBQ-187 Get all namespaces of all Wikipedias
Status: RESOLVED FIXED
Product: Tool Labs tools
Classification: Unclassified
Database Queries (Other open bugs)
unspecified
All All
: Unprioritized trivial
: ---
Assigned To: Bugzilla Bug Importer (valhallasw)
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-01-03 16:10 UTC by Bugzilla Bug Importer (valhallasw)
Modified: 2014-01-03 16:10 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Bugzilla Bug Importer (valhallasw) 2014-01-03 16:10:53 UTC
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.
Comment 1 Bugzilla Bug Importer (valhallasw) 2014-01-03 16:10:55 UTC
-------------------------------------------------------------------------------
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
Comment 2 Bugzilla Bug Importer (valhallasw) 2014-01-03 16:10:56 UTC
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

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links