- commit
- e8eafe7
- parent
- 1bb6dd5
- author
- Eric Bower
- date
- 2024-11-30 19:28:49 +0000 UTC
fix(analytics): limit user sites to valid http.status
1 files changed,
+1,
-1
+1,
-1
1@@ -1159,7 +1159,7 @@ func (me *PsqlDB) visitHost(opts *db.SummaryOpts) ([]*db.VisitUrl, error) {
2 host,
3 count(DISTINCT ip_address) as host_count
4 FROM analytics_visits
5- WHERE user_id = $1 AND host <> ''
6+ WHERE user_id = $1 AND host <> '' AND status >= 200 AND status < 300
7 GROUP BY host
8 ORDER BY host_count DESC`
9