Last modified: 2014-01-03 16:06:40 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-162. Summary: finding number of interwiki between some wikis Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: amir <ab3550@gmail.com> Date: Mon, 24 Oct 2011 01:44:36 ------------------------------------------------------------------------------- Hi, I want a query that tell me number of interwiki between en wiki and de,it,fr,es,ar,he,fa,tr in namespace main and category. thank you
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Mon, 24 Oct 2011 18:02:15 ------------------------------------------------------------------------------- Please note, that the result contains only links set on enwiki (and not from the other wikis towards enwiki). SQL: SELECT /* SLOW_OK */ ll_lang as lang, page_namespace as namespace, COUNT(*) as number FROM langlinks INNER JOIN page on ll_from = page_id WHERE ll_lang IN('de', 'it', 'fr', 'es', 'ar', 'he', 'fa', 'tr') AND page_namespace IN(0,14) GROUP BY ll_lang, page_namespace; Result: http://toolserver.org/~hoo/dbq/dbq-162.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, ab3550@gmail.com