gistfile1.txt

# Here's what the scope was before
    scope :by_most_recent_post, joins(:posts).order('forem_posts.created_at DESC, forem_topics.id').group('topic_id')                                                                                             
    scope :by_pinned_or_most_recent_post, includes(:posts).
                                          order('forem_topics.pinned DESC').
                                          order('forem_posts.created_at DESC').
                                          order('forem_topics.id')

# Here's what it likely should be, based on the by pinned or most recent scope
    scope :by_most_recent_post, includes(:posts).order('forem_posts.created_at DESC)                                            
    scope :by_pinned_or_most_recent_post, includes(:posts).
                                          order('forem_topics.pinned DESC').
                                          order('forem_posts.created_at DESC').
                                          order('forem_topics.id')