Sbisson has uploaded a new change for review.
https://gerrit.wikimedia.org/r/226524
Change subject: Include all contributing users in 'unique-users' query
......................................................................
Include all contributing users in 'unique-users' query
* Remove the restriction on rev_change_type to include all
possible changes: new topic, reply, edit description,
moderation, etc.
Bug: T106564
Change-Id: I42ff62c13e5e89ca31a5e8d3fad0db931eb2abae
---
M flow/unique-users.sql
1 file changed, 1 insertion(+), 2 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-flow-data
refs/changes/24/226524/1
diff --git a/flow/unique-users.sql b/flow/unique-users.sql
index 0921ee9..4b933fa 100644
--- a/flow/unique-users.sql
+++ b/flow/unique-users.sql
@@ -4,8 +4,7 @@
SELECT 1 as user,
DATE(DATE_SUB(FROM_UNIXTIME((conv(substring(hex(rev_id),1,12),16,10)>>2)/1000),
interval DAYOFWEEK(
FROM_UNIXTIME((conv(substring(hex(rev_id),1,12),16,10)>>2)/1000)) day)) as
weekstart
FROM flow_revision
- WHERE rev_change_type = 'reply'
- AND rev_user_wiki NOT IN ( 'testwiki', 'test2wiki' )
+ WHERE rev_user_wiki NOT IN ( 'testwiki', 'test2wiki' )
GROUP BY rev_user_wiki, rev_user_id, rev_user_ip
) x
WHERE weekstart < DATE_SUB(CURDATE(), interval DAYOFWEEK(NOW()) day)
--
To view, visit https://gerrit.wikimedia.org/r/226524
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I42ff62c13e5e89ca31a5e8d3fad0db931eb2abae
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-flow-data
Gerrit-Branch: master
Gerrit-Owner: Sbisson <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
