SELECT
domain, count(domain) as hits
FROM records
WHERE (
session != 0 AND categories == 0 AND user_id NOT IN ('127.0.0.1', '-') AND verdict != 'bypass' AND response_code == 200 AND request_method == 'CONNECT'
)
GROUP BY domain
HAVING hits > 50
ORDER BY hits
DESC
LIMIT 1000