WH most-visited hosts

Custom SQL query returning 100 rows (hide)

SELECT visitee_full, admin,
    COUNT(*) AS n_visits,
    COUNT(DISTINCT visitor_name_hash) AS distinct_visitors,
    SUM(visitor_is_tour) AS tour_visits
FROM wh_visits
WHERE visitee_full IS NOT NULL
GROUP BY visitee_full, admin
ORDER BY n_visits DESC
LIMIT 100

Edit SQL