faster bridge get trending for develop

hive/db/schema.py

@@ -1779,7 +1779,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
     """
@@ -1843,13 +1843,13 @@ def set_logged_table_attribute(db, logged):
         db.query_no_return(sql.format(table, 'LOGGED' if logged else 'UNLOGGED'))
 
 def execute_sql_script(query_executor, path_to_script):
-    """ Load and execute sql script from file 
+    """ Load and execute sql script from file
         Params:
           query_executor - callable to execute query with
           path_to_script - path to script
         Returns:
           depending on query_executor
-          
+
         Example:
           print(execute_sql_script(db.query_row, "./test.sql"))
           where test_sql: SELECT * FROM hive_state WHERE block_num = 0;
@@ -1864,4 +1864,4 @@ def execute_sql_script(query_executor, path_to_script):
     except Exception as ex:
         log.exception("Error running sql script: {}".format(ex))
         raise ex
-    return None
\ No newline at end of file
+    return None