analytics.sql

1SELECT
2	host,
3	count(DISTINCT ip_address) as host_count
4FROM analytics_visits
5WHERE user_id = '87dcabcb-5888-4b99-9b64-212651abe480' AND host <> ''
6GROUP BY host
7ORDER BY host_count DESC;