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