https://bugzilla.wikimedia.org/show_bug.cgi?id=59335

       Web browser: ---
            Bug ID: 59335
           Summary: DBQ-81 Generate interlanguage link table for 30
                    selected languages
           Product: Tool Labs tools
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: Unprioritized
         Component: Database Queries
          Assignee: wmf.bugconver...@gmail.com
          Reporter: wmf.bugconver...@gmail.com
    Classification: Unclassified
   Mobile Platform: ---

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  <hant...@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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to