KartikMistry has uploaded a new change for review.
https://gerrit.wikimedia.org/r/214309
Change subject: Add languages to be deployed on 20150528
......................................................................
Add languages to be deployed on 20150528
Change-Id: I149370f917bbd0e07e4931c29186b225430756ba
---
M language/content_translation_beta.sql
M language/content_translation_beta_manual.sql
M reportgenerator/config/config.json
3 files changed, 109 insertions(+), 3 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-language-data
refs/changes/09/214309/1
diff --git a/language/content_translation_beta.sql
b/language/content_translation_beta.sql
index 5daf825..74ee885 100644
--- a/language/content_translation_beta.sql
+++ b/language/content_translation_beta.sql
@@ -119,7 +119,23 @@
gnwiki,
extwiki,
papwiki,
- ltwiki
+ ltwiki,
+ bat-smgwiki,
+ bswiki,
+ etwiki,
+ fiwiki,
+ fiu-vrowiki,
+ fywiki,
+ hrwiki,
+ huwiki,
+ nds-nlwiki,
+ nlwiki,
+ rowiki,
+ sewiki,
+ skwiki,
+ srwiki,
+ szlwiki,
+ vepwiki
from (select *
from ( select count(*) as cawiki from cawiki.user_properties where
up_property = 'cx' and up_value = 1 ) ca
@@ -184,7 +200,9 @@
left join
( select count(*) as koiwiki from koiwiki.user_properties
where up_property = 'cx' and up_value = 1 ) koi on 1=1
) first30
+
cross join
+
(select *
from ( select count(*) as kvwiki from kvwiki.user_properties where
up_property = 'cx' and up_value = 1 ) kv
left join
@@ -361,6 +379,42 @@
( select count(*) as papwiki from papwiki.user_properties
where up_property = 'cx' and up_value = 1 ) pap on 1=1
left join
( select count(*) as ltwiki from ltwiki.user_properties where
up_property = 'cx' and up_value = 1 ) lt on 1=1
+ left join
+ ( select count(*) as bat-smgwiki from
bat-smgwiki.user_properties where up_property = 'cx' and up_value = 1 ) bat-smg
on 1=1
+ left join
+ ( select count(*) as bswiki from bswiki.user_properties where
up_property = 'cx' and up_value = 1 ) bs on 1=1
+ left join
+ ( select count(*) as etwiki from etwiki.user_properties where
up_property = 'cx' and up_value = 1 ) et on 1=1
+ left join
+ ( select count(*) as fiwiki from fiwiki.user_properties where
up_property = 'cx' and up_value = 1 ) fi on 1=1
+ left join
+ ( select count(*) as fiu-vrowiki from
fiu-vrowiki.user_properties where up_property = 'cx' and up_value = 1 ) fiu-vro
on 1=1
+ left join
+ ( select count(*) as fywiki from fywiki.user_properties where
up_property = 'cx' and up_value = 1 ) fy on 1=1
+ left join
+ ( select count(*) as hrwiki from hrwiki.user_properties where
up_property = 'cx' and up_value = 1 ) hr on 1=1
+ left join
+ ( select count(*) as huwiki from huwiki.user_properties where
up_property = 'cx' and up_value = 1 ) hu on 1=1
) forth30
+ cross join
+
+ (select *
+ from ( select count(*) as nds-nlwiki from
nds-nlwiki.user_properties where up_property = 'cx' and up_value = 1 ) nds-nl
+ left join
+ ( select count(*) as nlwiki from nlwiki.user_properties where
up_property = 'cx' and up_value = 1 ) nl on 1=1
+ left join
+ ( select count(*) as rowiki from rowiki.user_properties where
up_property = 'cx' and up_value = 1 ) ro on 1=1
+ left join
+ ( select count(*) as sewiki from sewiki.user_properties where
up_property = 'cx' and up_value = 1 ) se on 1=1
+ left join
+ ( select count(*) as skwiki from skwiki.user_properties where
up_property = 'cx' and up_value = 1 ) sk on 1=1
+ left join
+ ( select count(*) as srwiki from srwiki.user_properties where
up_property = 'cx' and up_value = 1 ) sr on 1=1
+ left join
+ ( select count(*) as szlwiki from szlwiki.user_properties
where up_property = 'cx' and up_value = 1 ) szl on 1=1
+ left join
+ ( select count(*) as vepwiki from vepwiki.user_properties
where up_property = 'cx' and up_value = 1 ) vep on 1=1
+ ) fifth30
+
;
diff --git a/language/content_translation_beta_manual.sql
b/language/content_translation_beta_manual.sql
index ac09c7f..1b491ae 100644
--- a/language/content_translation_beta_manual.sql
+++ b/language/content_translation_beta_manual.sql
@@ -119,7 +119,23 @@
gnwiki,
extwiki,
papwiki,
- ltwiki
+ ltwiki,
+ bat-smgwiki,
+ bswiki,
+ etwiki,
+ fiwiki,
+ fiu-vrowiki,
+ fywiki,
+ hrwiki,
+ huwiki,
+ nds-nlwiki,
+ nlwiki,
+ rowiki,
+ sewiki,
+ skwiki,
+ srwiki,
+ szlwiki,
+ vepwiki
from (select *
from ( select count(*) as cawiki from cawiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
cawiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) ca
@@ -363,6 +379,42 @@
( select count(*) as papwiki from papwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from papwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) pap on 1=1
left join
( select count(*) as ltwiki from ltwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
ltwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) lt on 1=1
+ left join
+ ( select count(*) as bat-smgwiki from
bat-smgwiki.user_properties where up_property = 'cx' and up_value = 1 and
up_user not in ( select up_user from bat-smgwiki.user_properties where
up_property = 'betafeatures-auto-enroll' and up_value = 1 ) ) bat-smg on 1=1
+ left join
+ ( select count(*) as bswiki from bswiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
bswiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) bs on 1=1
+ left join
+ ( select count(*) as etwiki from etwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
etwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) et on 1=1
+ left join
+ ( select count(*) as fiwiki from fiwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
fiwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) fi on 1=1
+ left join
+ ( select count(*) as fiu-vrowiki from
fiu-vrowiki.user_properties where up_property = 'cx' and up_value = 1 and
up_user not in ( select up_user from fiu-vrowiki.user_properties where
up_property = 'betafeatures-auto-enroll' and up_value = 1 ) ) fiu-vro on 1=1
+ left join
+ ( select count(*) as fywiki from fywiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
fywiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) fy on 1=1
+ left join
+ ( select count(*) as hrwiki from hrwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
hrwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) hr on 1=1
) forth30
+ cross join
+
+ (select *
+ from ( select count(*) as huwiki from huwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
huwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) hu
+ left join
+ ( select count(*) as nds-nlwiki from
nds-nlwiki.user_properties where up_property = 'cx' and up_value = 1 and
up_user not in ( select up_user from nds-nlwiki.user_properties where
up_property = 'betafeatures-auto-enroll' and up_value = 1 ) ) nds-nl on 1=1
+ left join
+ ( select count(*) as nlwiki from nlwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
nlwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) nl on 1=1
+ left join
+ ( select count(*) as rowiki from rowiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
rowiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) ro on 1=1
+ left join
+ ( select count(*) as sewiki from sewiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
sewiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) se on 1=1
+ left join
+ ( select count(*) as skwiki from skwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
skwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) sk on 1=1
+ left join
+ ( select count(*) as srwiki from srwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
srwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) sr on 1=1
+ left join
+ ( select count(*) as szlwiki from szlwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from szlwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) szl on 1=1
+ left join
+ ( select count(*) as vepwiki from vepwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from vepwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) vep on 1=1
+ ) fifth30
+
;
diff --git a/reportgenerator/config/config.json
b/reportgenerator/config/config.json
index 28cd428..495af4c 100644
--- a/reportgenerator/config/config.json
+++ b/reportgenerator/config/config.json
@@ -1,3 +1,3 @@
{
- "languages": [ "ca", "da", "eo", "es", "id", "ky", "ms", "nn", "no",
"pa", "pt", "sv", "min", "uz", "kn", "uk", "bg", "fr", "mk", "sh", "sl", "gu",
"vi", "af", "an", "ast", "ba", "cv", "eu", "gl", "koi", "kv", "lez", "oc",
"sah", "simple", "tt", "tyv", "udm", "xh", "cs", "el", "kk", "zu", "ak", "bm",
"ee", "ff", "kg", "ki", "lg", "ny", "om", "rn", "sg", "ss", "st", "ti", "tn",
"ts", "tum", "tw", "ve", "ab", "av", "az", "crh", "gag", "hy", "kaa", "kbd",
"krc", "lad", "mt", "mwl", "os", "rmy", "roa-rup", "sq", "tr", "war", "ceb",
"tl", "cbk-zam", "pam", "pag", "ilo", "be-x-old", "be", "bcl", "ka", "rue",
"csb", "ltg", "lv", "li", "bh", "pl", "hi", "sw", "so", "sn", "yo", "am",
"kab", "wo", "ig", "nso", "qu", "nah", "ay", "gn", "ext", "pap", "lt" ]
+ "languages": [ "ca", "da", "eo", "es", "id", "ky", "ms", "nn", "no",
"pa", "pt", "sv", "min", "uz", "kn", "uk", "bg", "fr", "mk", "sh", "sl", "gu",
"vi", "af", "an", "ast", "ba", "cv", "eu", "gl", "koi", "kv", "lez", "oc",
"sah", "simple", "tt", "tyv", "udm", "xh", "cs", "el", "kk", "zu", "ak", "bm",
"ee", "ff", "kg", "ki", "lg", "ny", "om", "rn", "sg", "ss", "st", "ti", "tn",
"ts", "tum", "tw", "ve", "ab", "av", "az", "crh", "gag", "hy", "kaa", "kbd",
"krc", "lad", "mt", "mwl", "os", "rmy", "roa-rup", "sq", "tr", "war", "ceb",
"tl", "cbk-zam", "pam", "pag", "ilo", "be-x-old", "be", "bcl", "ka", "rue",
"csb", "ltg", "lv", "li", "bh", "pl", "hi", "sw", "so", "sn", "yo", "am",
"kab", "wo", "ig", "nso", "qu", "nah", "ay", "gn", "ext", "pap", "lt",
"bat-smg", "bs", "et", "fi", "fiu-vro", "fy", "hr", "hu", "nds-nl", "nl", "ro",
"se", "sk", "sr", "szl", "vep" ]
}
--
To view, visit https://gerrit.wikimedia.org/r/214309
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I149370f917bbd0e07e4931c29186b225430756ba
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-language-data
Gerrit-Branch: master
Gerrit-Owner: KartikMistry <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
