KartikMistry has uploaded a new change for review.
https://gerrit.wikimedia.org/r/183788
Change subject: Correct list of wikis
......................................................................
Correct list of wikis
Change-Id: Ic8f933e4969d1986c66c51bf69a366dc5b08199c
---
M language/content_translation_beta.sql
1 file changed, 6 insertions(+), 8 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-language-data
refs/changes/88/183788/1
diff --git a/language/content_translation_beta.sql
b/language/content_translation_beta.sql
index 16f877a..b5c921a 100644
--- a/language/content_translation_beta.sql
+++ b/language/content_translation_beta.sql
@@ -1,19 +1,17 @@
select *
- from (select count(*) as enwiki from enwiki.user_properties where
up_property = 'cx') en
- left join
- (select count(*) as cawiki from cawiki.user_properties where
up_property = 'cx') ca on 1=1
- left join
- (select count(*) as eswiki from eswiki.user_properties where
up_property = 'cx') es on 1=1
- left join
- (select count(*) as ptwiki from ptwiki.user_properties where
up_property = 'cx') pt on 1=1
+ from (select count(*) as cawiki from cawiki.user_properties where
up_property = 'cx') ca
left join
(select count(*) as dawiki from dawiki.user_properties where
up_property = 'cx') da on 1=1
left join
(select count(*) as eowiki from eowiki.user_properties where
up_property = 'cx') eo on 1=1
left join
+ (select count(*) as eswiki from eswiki.user_properties where
up_property = 'cx') es on 1=1
+ left join
(select count(*) as idwiki from idwiki.user_properties where
up_property = 'cx') id on 1=1
left join
(select count(*) as mswiki from mswiki.user_properties where
up_property = 'cx') ms on 1=1
left join
- (select count(*) as sawiki from sawiki.user_properties where
up_property = 'cx') sa on 1=1
+ (select count(*) as nbwiki from nbwiki.user_properties where
up_property = 'cx') nb on 1=1
+ left join
+ (select count(*) as ptwiki from ptwiki.user_properties where
up_property = 'cx') pt on 1=1
;
--
To view, visit https://gerrit.wikimedia.org/r/183788
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic8f933e4969d1986c66c51bf69a366dc5b08199c
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
