Querying pingback statistics

Author
Created	1 March 2018 13:41:51
Last Modified	1 March 2018 13:49:24
Tags

1. ssh to stat1006.eqiad.wmnet

mysql --defaults-extra-file="/etc/mysql/conf.d/research-client.cnf" -h analytics-slave.eqiad.wmnet -e "select left(event_MediaWiki,6),count(*) from log.MediaWikiPingback_15781718 where event_MediaWiki !=  group by left(event_MediaWiki,6) order by event_MediaWiki;"