This issue was converted from https://jira.toolserver.org/browse/DBQ-81.
Summary: Generate interlanguage link table for 30 selected languages
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: (none)

From: Hanteng <hanteng@gmail.com>

Date: Tue, 01 Dec 2009 16:16:13

To construct a two-way linking table for 30 selected languages based on interlanguage links for corresponding Wikipedias.

The SQL query is given as below. (Thank Mr. Daniel Kinzler for giving the first few examples.)

select ll_lang, count(*) as c from langlinks group by ll_lang order by c desc where ll_language in ('id', 'ja', km', 'ko', 'lo', 'mn', 'ms', 'my', 'ta', 'th', 'tl', 'vi', 'zh', 'da', 'fi', 'sv', 'no', 'is', 'it', 'pl', 'cs', 'sk', 'hi', 'ar', 'nl', 'de', 'es', 'pt', 'fr', 'en');

For each of the 30 selected languages listed ('id', 'ja', km', 'ko', 'lo', 'mn', 'ms', 'my', 'ta', 'th', 'tl', 'vi', 'zh', 'da', 'fi', 'sv', 'no', 'is', 'it', 'pl', 'cs', 'sk', 'hi', 'ar', 'nl', 'de', 'es', 'pt', 'fr', 'en'), repeat executing the same query.

Please generate the output in simple plain csv format.

Version: unspecified
Severity: major