Continued:

- only list entries where the software has been detected
- still this will list non-fediverse "instances" such as normal websites

diff --git a/api.py b/api.py
index 520cad0fc88b2639af158868bf0db7094a83e58f..b37e555e072b7e3185a15200b254264c95419b23 100644 (file)
--- a/api.py
+++ b/api.py
@@ -56,7 +56,7 @@ def top(blocked: int = None, blockers: int = None, reference: int = None, softwa
     elif reference != None:
         if reference > 500:
             raise HTTPException(status_code=400, detail="Too many results")
-        fba.cursor.execute("SELECT origin, COUNT(domain) FROM instances GROUP BY origin ORDER BY COUNT(domain) DESC LIMIT ?", [reference])
+        fba.cursor.execute("SELECT origin, COUNT(domain) FROM instances WHERE software IS NOT NULL GROUP BY origin ORDER BY COUNT(domain) DESC LIMIT ?", [reference])
     elif software != None:
         if software > 500:
             raise HTTPException(status_code=400, detail="Too many results")