dynamically generated notifs

Some of the notifications can be extracted from DB tables with SQL query. This allows us to avoid redundancy and save db space.

hive/indexer/follow.py

@@ -272,15 +272,15 @@ class Follow:
         log.info("[SYNC] query follower counts")
         sql = """
             CREATE TEMPORARY TABLE following_counts AS (
-                  SELECT id account_id, COUNT(state) num
-                    FROM hive_accounts
-               LEFT JOIN hive_follows hf ON id = hf.follower AND state = 1
-                GROUP BY id);
+                  SELECT ha.id account_id, COUNT(state) num
+                    FROM hive_accounts ha
+               LEFT JOIN hive_follows hf ON ha.id = hf.follower AND state = 1
+                GROUP BY ha.id);
             CREATE TEMPORARY TABLE follower_counts AS (
-                  SELECT id account_id, COUNT(state) num
-                    FROM hive_accounts
-               LEFT JOIN hive_follows hf ON id = hf.following AND state = 1
-                GROUP BY id);
+                  SELECT ha.id account_id, COUNT(state) num
+                    FROM hive_accounts ha
+               LEFT JOIN hive_follows hf ON ha.id = hf.following AND state = 1
+                GROUP BY ha.id);
         """
         DB.query(sql)