| SELECT SUM(IF(user_agent LIKE '%Safari/534.30%', 1, 0))/SUM(1) AS... |
7 years ago |
| SELECT user_agent, COUNT(*) AS views
FROM wmf.webrequest
WHERE year = 2017... |
7 years ago |
| SELECT
COUNT(DISTINCT ip) AS hits
FROM
webrequest
WHERE
year = 2017
... |
7 years ago |
