Halfway done with hot rank indexes.

[lemmy.git] / lemmy_db_views / src / post_view.rs

diff --git a/lemmy_db_views/src/post_view.rs b/lemmy_db_views/src/post_view.rs
index 4caa1f02139000393fbb6ea04d551d6265fe6cf2..703ab1670d50cceeac7ee6e01b15649cfc85144b 100644 (file)
--- a/lemmy_db_views/src/post_view.rs
+++ b/lemmy_db_views/src/post_view.rs
@@ -349,10 +349,10 @@ impl<'a> PostQueryBuilder<'a> {
         .then_order_by(
           hot_rank(post_aggregates::score, post_aggregates::newest_comment_time).desc(),
         )
-        .then_order_by(post::published.desc()),
+        .then_order_by(post_aggregates::newest_comment_time.desc()),
       SortType::Hot => query
-        .then_order_by(hot_rank(post_aggregates::score, post::published).desc())
-        .then_order_by(post::published.desc()),
+        .then_order_by(hot_rank(post_aggregates::score, post_aggregates::published).desc())
+        .then_order_by(post_aggregates::published.desc()),
       SortType::New => query.then_order_by(post::published.desc()),
       SortType::TopAll => query.then_order_by(post_aggregates::score.desc()),
       SortType::TopYear => query
@@ -601,6 +601,7 @@ mod tests {
         score: 1,
         upvotes: 1,
         downvotes: 0,
+        published: agg.published,
         newest_comment_time: inserted_post.published,
       },
       subscribed: false,