- SQL
- sort_order = DB.query_single(sql).first
- end
- sort_order
- end
- def filter_post_types(posts)
- return posts.where(post_type: Post.types[:regular]) if @only_regular
- posts.where(post_type: Topic.visible_post_types(@user))
- end
- def filter_posts_by_post_number(post_number, asc)
- sort_order = get_sort_order(post_number)
- posts =
- if asc
- @filtered_posts.where("sort_order > ?", sort_order)