Last modified: 2013-08-22 14:54:30 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 T47889, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 45889 - Request a query to know which namespaces are used in one or few wikis
Request a query to know which namespaces are used in one or few wikis
Status: VERIFIED FIXED
Product: Wikimedia
Classification: Unclassified
Wikidata (Other open bugs)
unspecified
All All
: Normal enhancement (vote)
: ---
Assigned To: Wikidata bugs
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-03-08 08:25 UTC by reza1615
Modified: 2013-08-22 14:54 UTC (History)
2 users (show)

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


Attachments

Description reza1615 2013-03-08 08:25:20 UTC
Hi,
Please tell me or show me place that shows which wikipedias uses specific namespace that are not in other wikis.
we need them for 
https://www.wikidata.org/wiki/Wikidata:Requests_for_comment/Inclusion_of_non-article_pages_2#Other_namespaces.2C_that_exist_only_on_individual_wikipedias
to have better conclusion 

for example :
book: en, fa,....
Anexo: es
wikiproject:
Comment 1 Sam Reed (reedy) 2013-03-08 08:33:01 UTC
I'm not sure how you're wanting to do it.

Some wikis have namespaces with the same numbers, which are completely different namespaces...
Comment 2 reza1615 2013-03-08 08:47:29 UTC
How can I have a query to have list of all namespaces in all wikipedias?

By sure namespace from -1 to 14 in all wikis are the same (mediawiki default). for rest of them most of Wikipedias don't have more than this in my opinion  we can limit out query to 50-60 wikis.
Comment 3 Kunal Mehta (Legoktm) 2013-03-08 08:52:18 UTC
I ran a simple query:
mysql> select dbname, ns_name from namespacename where dbname LIKE "%wiki_p" AND ns_id >14 AND ns_id%2=0;

Results at [[d:User:Legoktm/namespaces]]
Comment 4 reza1615 2013-03-08 09:00:12 UTC
(In reply to comment #3)
> I ran a simple query:
> mysql> select dbname, ns_name from namespacename where dbname LIKE "%wiki_p"
> AND ns_id >14 AND ns_id%2=0;
> 
> Results at [[d:User:Legoktm/namespaces]]

great! would you please add ns_id to list?
Comment 5 reza1615 2013-03-08 09:01:50 UTC
also
fawiki_p           | کتاب                          |
| fawiki_p           | Book                              |
| fawiki_p           | كتاب                          |
are the same
Comment 6 Kunal Mehta (Legoktm) 2013-03-08 09:07:59 UTC
(In reply to comment #4)


> great! would you please add ns_id to list?

Done.

(In reply to comment #5)
> also
> fawiki_p           | کتاب                          |
> | fawiki_p           | Book                              |
> | fawiki_p           | كتاب                          |
> are the same

Fixed by using ns_is_favorite=1.

Marking as resolved and "fixed".
Comment 7 reza1615 2013-03-08 10:11:21 UTC
thanks I separated them by their title at this link
https://www.wikidata.org/wiki/User_talk:Legoktm/namespaces
Comment 8 denny vrandecic 2013-08-22 14:54:30 UTC
Closed older resolved bugs as verified.

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


Navigation
Links