faster bridge get trending

hive/db/schema.py

@@ -1401,7 +1401,7 @@ def setup(db):
         		, hp1.sc_trend as trend
         	  FROM hive_posts hp1 WHERE NOT hp1.is_paidout AND hp1.depth = 0 ORDER BY hp1.sc_trend DESC LIMIT _limit
            ) as trends
-           JOIN hive_posts_view hp ON hp.id = trends.id
+           JOIN hive_posts_view hp ON hp.id = trends.id ORDER BY trends.trend DESC
         $function$
         language sql
     """