KartikMistry has uploaded a new change for review.
https://gerrit.wikimedia.org/r/215930
Change subject: Add languages to deploy on 20150604
......................................................................
Add languages to deploy on 20150604
Change-Id: I537b9f23d72512f035f7f391ae2a292e1df07397
---
M language/content_translation_beta.sql
M language/content_translation_beta_manual.sql
M reportgenerator/config/config.json
3 files changed, 105 insertions(+), 3 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-language-data
refs/changes/30/215930/1
diff --git a/language/content_translation_beta.sql
b/language/content_translation_beta.sql
index 74ee885..b45c957 100644
--- a/language/content_translation_beta.sql
+++ b/language/content_translation_beta.sql
@@ -135,7 +135,24 @@
skwiki,
srwiki,
szlwiki,
- vepwiki
+ vepwiki,
+ aswiki,
+ bnwiki,
+ bpywiki
+ mywiki,
+ dzwiki,
+ kmwiki,
+ lowiki,
+ mlwiki,
+ mrwiki,
+ newiki,
+ newwiki,
+ orwiki,
+ piwiki,
+ sawiki,
+ siwiki,
+ tewiki,
+ thwiki
from (select *
from ( select count(*) as cawiki from cawiki.user_properties where
up_property = 'cx' and up_value = 1 ) ca
@@ -415,6 +432,40 @@
( 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
+ left join
+ ( select count(*) as aswiki from aswiki.user_properties where
up_property = 'cx' and up_value = 1 ) as on 1=1
+ left join
+ ( select count(*) as bnwiki from bnwiki.user_properties where
up_property = 'cx' and up_value = 1 ) bn on 1=1
+ left join
+ ( select count(*) as bpywiki from bpywiki.user_properties
where up_property = 'cx' and up_value = 1 ) bpy on 1=1
+ left join
+ ( select count(*) as mywiki from mywiki.user_properties where
up_property = 'cx' and up_value = 1 ) my on 1=1
+ left join
+ ( select count(*) as dzwiki from dzwiki.user_properties where
up_property = 'cx' and up_value = 1 ) dz on 1=1
+ left join
+ ( select count(*) as kmwiki from kmwiki.user_properties where
up_property = 'cx' and up_value = 1 ) km on 1=1
+ left join
+ ( select count(*) as lowiki from lowiki.user_properties where
up_property = 'cx' and up_value = 1 ) lo on 1=1
+ left join
+ ( select count(*) as mlwiki from mlwiki.user_properties where
up_property = 'cx' and up_value = 1 ) ml on 1=1
+ left join
+ ( select count(*) as mrwiki from mrwiki.user_properties where
up_property = 'cx' and up_value = 1 ) mr on 1=1
+ left join
+ ( select count(*) as newiki from newiki.user_properties where
up_property = 'cx' and up_value = 1 ) ne on 1=1
+ left join
+ ( select count(*) as newwiki from newwiki.user_properties
where up_property = 'cx' and up_value = 1 ) new on 1=1
+ left join
+ ( select count(*) as orwiki from orwiki.user_properties where
up_property = 'cx' and up_value = 1 ) or on 1=1
+ left join
+ ( select count(*) as piwiki from piwiki.user_properties where
up_property = 'cx' and up_value = 1 ) pi on 1=1
+ left join
+ ( select count(*) as sawiki from sawiki.user_properties where
up_property = 'cx' and up_value = 1 ) sa on 1=1
+ left join
+ ( select count(*) as siwiki from siwiki.user_properties where
up_property = 'cx' and up_value = 1 ) si on 1=1
+ left join
+ ( select count(*) as tewiki from tewiki.user_properties where
up_property = 'cx' and up_value = 1 ) te on 1=1
+ left join
+ ( select count(*) as thwiki from thwiki.user_properties where
up_property = 'cx' and up_value = 1 ) th on 1=1
) fifth30
;
diff --git a/language/content_translation_beta_manual.sql
b/language/content_translation_beta_manual.sql
index 3b29827..48abbb0 100644
--- a/language/content_translation_beta_manual.sql
+++ b/language/content_translation_beta_manual.sql
@@ -135,7 +135,24 @@
skwiki,
srwiki,
szlwiki,
- vepwiki
+ vepwiki,
+ aswiki,
+ bnwiki,
+ bpywiki
+ mywiki,
+ dzwiki,
+ kmwiki,
+ lowiki,
+ mlwiki,
+ mrwiki,
+ newiki,
+ newwiki,
+ orwiki,
+ piwiki,
+ sawiki,
+ siwiki,
+ tewiki,
+ thwiki
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
@@ -415,6 +432,40 @@
( 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
+ left join
+ ( select count(*) as aswiki from aswiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
aswiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) as on 1=1
+ left join
+ ( select count(*) as bnwiki from bnwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
bnwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) bn on 1=1
+ left join
+ ( select count(*) as bpywiki from bpywiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from bpywiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) bpy on 1=1
+ left join
+ ( select count(*) as mywiki from mywiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
mywiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) my on 1=1
+ left join
+ ( select count(*) as dzwiki from dzwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
dzwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) dz on 1=1
+ left join
+ ( select count(*) as kmwiki from kmwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
kmwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) km on 1=1
+ left join
+ ( select count(*) as lowiki from lowiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
lowiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) lo on 1=1
+ left join
+ ( select count(*) as mlwiki from mlwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
mlwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) ml on 1=1
+ left join
+ ( select count(*) as mrwiki from mrwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
mrwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) mr on 1=1
+ left join
+ ( select count(*) as newiki from newiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
newiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) ne on 1=1
+ left join
+ ( select count(*) as newwiki from newwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from newwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) new on 1=1
+ left join
+ ( select count(*) as orwiki from orwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
orwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) or on 1=1
+ left join
+ ( select count(*) as piwiki from piwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
piwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) pi on 1=1
+ left join
+ ( select count(*) as sawiki from sawiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
sawiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) sa on 1=1
+ left join
+ ( select count(*) as siwiki from siwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
siwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) si on 1=1
+ left join
+ ( select count(*) as tewiki from tewiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
tewiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) te on 1=1
+ left join
+ ( select count(*) as thwiki from thwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
thwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) th on 1=1
) fifth30
;
diff --git a/reportgenerator/config/config.json
b/reportgenerator/config/config.json
index 495af4c..a459841 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",
"bat-smg", "bs", "et", "fi", "fiu-vro", "fy", "hr", "hu", "nds-nl", "nl", "ro",
"se", "sk", "sr", "szl", "vep" ]
+ "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", "as", "bn", "bpy", "my", "dz", "km", "lo",
"ml", "mr", "ne", "new", "or", "pi", "sa", "si", "te", "th" ]
}
--
To view, visit https://gerrit.wikimedia.org/r/215930
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I537b9f23d72512f035f7f391ae2a292e1df07397
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
