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

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: merl <mewikipe...@to.mabomuja.de>
Date: Thu, 17 Dec 2009 16:48:10
-------------------------------------------------------------------------------

#! /bin/bash
    #$ -N DBQ-83
    #$ -hard
    #$ -l sqlprocs-s1=1
    #$ -l sqlprocs-s2=1
    #$ -l sqlprocs-s3=1
    wikilist="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"
    echo "wiki,interwiki,count" > DBQ-83.txt
    for runwiki in $wikilist
    do
      list=""
      for searchwiki in $wikilist
      do
        if [ "$searchwiki" != "$runwiki" ]
        then
          if [ -n "$list" ]
          then
            list="$list, "
          fi
          list="$list'$searchwiki'"
        fi
      done
      mysql -wBN -h${runwiki}wiki-p.db ${runwiki}wiki_p -e "select
CONCAT('${runwiki},', ll_lang, ',', count(*)) as csv from langlinks where
ll_lang in (${list}) group by ll_lang order by count(*) desc" >> DBQ-83.txt
    done

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