Milimetric has uploaded a new change for review. https://gerrit.wikimedia.org/r/227470
Change subject: Fixing repo - forgot to add downloads file ...................................................................... Fixing repo - forgot to add downloads file Change-Id: Id1cf477ce8f5f0910486eed2abd6e8ab7f0dbb60 --- A extdist/downloads.sql 1 file changed, 21 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-extdist-data refs/changes/70/227470/1 diff --git a/extdist/downloads.sql b/extdist/downloads.sql new file mode 100644 index 0000000..8d53379 --- /dev/null +++ b/extdist/downloads.sql @@ -0,0 +1,21 @@ +SELECT + LEFT(timestamp, 6) AS month, + event_type, + event_name, + event_version, + COUNT(uuid) AS count + +FROM + ExtDistDownloads_12369387 + +GROUP BY + month, + event_type, + event_name, + event_version + +ORDER BY + month ASC, + event_type ASC, + event_name, + event_version; -- To view, visit https://gerrit.wikimedia.org/r/227470 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Id1cf477ce8f5f0910486eed2abd6e8ab7f0dbb60 Gerrit-PatchSet: 1 Gerrit-Project: analytics/limn-extdist-data Gerrit-Branch: master Gerrit-Owner: Milimetric <dandree...@wikimedia.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits