X-Git-Url: http://these/git/?a=blobdiff_plain;f=crates%2Fdb_views_actor%2Fsrc%2Fperson_view.rs;h=2a7a2ce79466a935f731026337c592e4f368e615;hb=f5209fffc1de527db7ea007d463c158b36fda515;hp=c7876cc1c5e821b1d4291f02a0f5cb0e3d0bd038;hpb=50efb1d519c63a7007a07f11cc8a11487703c70d;p=lemmy.git diff --git a/crates/db_views_actor/src/person_view.rs b/crates/db_views_actor/src/person_view.rs index c7876cc1..2a7a2ce7 100644 --- a/crates/db_views_actor/src/person_view.rs +++ b/crates/db_views_actor/src/person_view.rs @@ -122,6 +122,15 @@ impl<'a> PersonQuery<'a> { SortType::TopTwelveHour => query .filter(person::published.gt(now - 12.hours())) .order_by(person_aggregates::comment_score.desc()), + SortType::TopThreeMonths => query + .filter(person::published.gt(now - 3.months())) + .order_by(person_aggregates::comment_score.desc()), + SortType::TopSixMonths => query + .filter(person::published.gt(now - 6.months())) + .order_by(person_aggregates::comment_score.desc()), + SortType::TopNineMonths => query + .filter(person::published.gt(now - 9.months())) + .order_by(person_aggregates::comment_score.desc()), }; let (limit, offset) = limit_and_offset(self.page, self.limit)?;