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

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: merl <mewikipe...@to.mabomuja.de>
Date: Tue, 01 Feb 2011 19:19:56
-------------------------------------------------------------------------------

Please note what you have requested:

  * column3=interwiki_count contains the number of all interwiki from one
project to one languange from ALL namespaces
  * column4=article_count contains the number of pages in content namespacey
ONLY. This is ns 0 in most wiki except arwiki  
I don't know what you mean by "the sum total of number of speakers", so i left
out this column. The column ll_lang is cut after 10 letters, so
zh-classical=zh-classic.

Here is the code i used for running at SGE

    #! /bin/bash
    #$ -N DBQ-122
    #$ -hard
    #$ -l sqlprocs-s1=1
    #$ -l sqlprocs-s2=1
    #$ -l sqlprocs-s3=1
    wikilist=`mysql -wBN -hsql-toolserver toolserver -e "SELECT
GROUP_CONCAT(REPLACE(dbname,'wiki_p','') SEPARATOR ' ') FROM wiki WHERE
family='wikipedia' AND is_closed=0 AND is_meta=0 ORDER BY dbname"`
    SQL="SELECT ss_good_articles FROM site_stats INTO @articles;
         SELECT CONCAT('%WIKI%,', ll_lang, ',', count(*),',',@articles) AS csv
FROM langlinks GROUP BY ll_lang ORDER BY ll_lang";
    echo "wiki,interwiki,interwiki_count,article_count" > DBQ-122.txt
    for runwiki in $wikilist
    do
      echo "querying $runwiki"
      runwiki2=`echo "$runwiki" | sed "s/_/-/g"`
      SQL2=`echo "$SQL" | sed "s/%WIKI%/$runwiki2/g"`
      mysql -wBN -h${runwiki2}wiki-p.rrdb ${runwiki}wiki_p -e "$SQL2" >>
DBQ-122.txt
    done


The output can be found at http://toolserver.org/~merl/sql/DBQ-122.txt

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