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>
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
Version: unspecified
Severity: major
From: Hoo man <hoo@online.de>
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;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