How is "TOP topics" list calculated?

zogstrip · September 25, 2015, 4:24pm

Have a look at the top_topic.rb file

app/models/top_topic.rb

main


      
          
          def self.update_op_likes_count_for(period)
            sql =
              "SELECT topic_id, like_count AS count
                     FROM posts
                     WHERE created_at >= :from
                       AND post_number = 1
                       AND deleted_at IS NULL
                       AND NOT hidden
                       AND post_type = #{Post.types[:regular]}"
          
            update_top_topics(period, "op_likes", sql)
          end
          
          def self.compute_top_score_for(period)
            log_views_multiplier = SiteSetting.top_topics_formula_log_views_multiplier.to_f
            log_views_multiplier = 2 if log_views_multiplier == 0
          
            first_post_likes_multiplier = SiteSetting.top_topics_formula_first_post_likes_multiplier.to_f
            first_post_likes_multiplier = 0.5 if first_post_likes_multiplier == 0

This file has been truncated. show original

Topic		Replies	Views
What makes a topic appear in the "Top" filter? Product Support	5	2566	September 4, 2016
An understandable explanation of 'Top'? Product Support	1	631	October 4, 2022
Calculating "Top" topics in Discourse Using Discourse reference , interface	2	2650	July 8, 2025
How is the "top" order determined Site feedback	4	3196	May 27, 2019
How do you track topic performance? Product Support	2	873	February 4, 2020

How is "TOP topics" list calculated?

Related topics