Ottomata has submitted this change and it was merged.
Change subject: Dropping all search and preview url's
......................................................................
Dropping all search and preview url's
Change-Id: Ib7911caf7088414392b8ad0e8f63c0e298f77008
---
M templates/misc/email-blog-pageviews.erb
1 file changed, 2 insertions(+), 2 deletions(-)
Approvals:
Ottomata: Verified; Looks good to me, approved
jenkins-bot: Verified
diff --git a/templates/misc/email-blog-pageviews.erb
b/templates/misc/email-blog-pageviews.erb
index ae655e8..1cf2535 100644
--- a/templates/misc/email-blog-pageviews.erb
+++ b/templates/misc/email-blog-pageviews.erb
@@ -12,8 +12,8 @@
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(event_referrerUrl, '/',
3), '/', -1), '.', -2) AS referer
FROM WikimediaBlogVisit_5308166
WHERE DATE(timestamp)=DATE('$DATE')
- AND event_requestUrl NOT LIKE '/?s=%'
- AND event_requestUrl NOT LIKE '/?p=%'
+ AND event_requestUrl NOT LIKE '%?s=%'
+ AND event_requestUrl NOT LIKE '%?p=%'
GROUP BY
event_requestUrl, referer
ORDER BY
--
To view, visit https://gerrit.wikimedia.org/r/56633
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Ib7911caf7088414392b8ad0e8f63c0e298f77008
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Diederik <[email protected]>
Gerrit-Reviewer: Ottomata <[email protected]>
Gerrit-Reviewer: jenkins-bot
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
