Last modified: 2014-01-03 15:48:56 UTC
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.
------------------------------------------------------------------------------- From: merl <mewikipedia@to.mabomuja.de> Date: Mon, 28 Dec 2009 01:03:08 ------------------------------------------------------------------------------- Same as <del>DBQ-83</del>. http://toolserver.org/~merl/sql/DBQ-81.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: (none) CC list: bugreporter@to.mabomuja.de, hanteng@gmail.com