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

       Web browser: ---
            Bug ID: 59337
           Summary: DBQ-83 Generate Interlanguage linking for 30 European
                    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-83.
Summary: Generate Interlanguage linking for 30 European languages
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: merl <mewikipe...@to.mabomuja.de>

-------------------------------------------------------------------------------
From: Thomasmp  <tm.petz...@gmail.com>
Date: Mon, 14 Dec 2009 04:29:51
-------------------------------------------------------------------------------

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

select ll_lang, count![][1] as c from langlinks group by ll_lang order by c
desc where ll_language in ('de', 'fr', 'nl', 'sv', 'en', 'it', 'da', 'ga',
'es', 'pt', 'cy', 'no', 'ca', 'hsb', 'br', 'ru', 'pl', 'cs', 'sk', 'hu', 'sl',
'hr', 'bs', 'sr', 'lt', 'uk', 'be', 'lv', 'bg', 'sq');

For each of the 30 selected languages listed ('de', 'fr', 'nl', 'sv', 'en',
'it', 'da', 'ga', 'es', 'pt', 'cy', 'no', 'ca', 'hsb', 'br', 'ru', 'pl', 'cs',
'sk', 'hu', 'sl', 'hr', 'bs', 'sr', 'lt', 'uk', 'be', 'lv', 'bg', 'sq'), repeat
executing the same query.

Please generate the output in simple plain csv format.

   [1]: https://jira.toolserver.org/images/icons/emoticons/star_yellow.gif

-- 
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