Gergő Tisza has uploaded a new change for review. https://gerrit.wikimedia.org/r/146158
Change subject: Fix action logging SQL query ...................................................................... Fix action logging SQL query Follow-up for Ia68a0ec5df629b8d4d8221a87bca5a777463d6f5 Change-Id: I2506e0c0cee695fdd8ea05a36b7ac40121ab1c94 --- M actions/template.sql 1 file changed, 1 insertion(+), 1 deletion(-) git pull ssh://gerrit.wikimedia.org:29418/analytics/multimedia refs/changes/58/146158/1 diff --git a/actions/template.sql b/actions/template.sql index 8ef6bc7..e040ac6 100644 --- a/actions/template.sql +++ b/actions/template.sql @@ -41,7 +41,7 @@ SELECT timestamp, event_action, event_samplingFactor FROM MediaViewer_8935662 WHERE %wiki% timestamp < TIMESTAMP(CURDATE()) AND timestamp >= TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY)) UNION ALL - SELECT timestamp, (CASE WHEN event_value = 0 THEN 'pref-optout-loggedin' else 'pref-optin-loggedin') as event_action, 1 as event_samplingFactor FROM PrefUpdate_5563398 WHERE event_property = 'multimediaviewer-enable' + SELECT timestamp, (CASE WHEN event_value = 0 THEN 'pref-optout-loggedin' ELSE 'pref-optin-loggedin' END) AS event_action, 1 AS event_samplingFactor FROM PrefUpdate_5563398 WHERE event_property = 'multimediaviewer-enable' ) AS MediaViewerUnioned GROUP BY datestring -- To view, visit https://gerrit.wikimedia.org/r/146158 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I2506e0c0cee695fdd8ea05a36b7ac40121ab1c94 Gerrit-PatchSet: 1 Gerrit-Project: analytics/multimedia Gerrit-Branch: master Gerrit-Owner: Gergő Tisza <gti...@wikimedia.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits