Draft: Refactor get_ranked_posts.sql to add a CTE to ensure posts get filtered by...

Refactor get_ranked_posts.sql to add a CTE to ensure posts get filtered by community_id first (fix big slowdown).

hive/db/sql_scripts/postgrest/utilities/get_account_posts.sql

@@ -407,7 +407,11 @@ BEGIN
       END
     )
     ) FROM (
+<<<<<<< HEAD
       WITH author_posts_comments AS -- get_account_posts_by_replies
+=======
+      WITH author_posts_comments AS
+>>>>>>> 25fbbf1f12de3db547a5830b993d7cb42135e1d4
       (
         SELECT id, author_id
         FROM hivemind_app.hive_posts