数据浏览器 - 投票计数

社区 数据与报告
,
2

Topic Voting 表是 discourse_voting_topic_votes 和 discourse_voting_votes。您可以使用类似以下内容包含每个主题的投票数：：+1：


SELECT
    t.id AS topic_id,
    t.title AS topic_title,
    dvtv.votes_count,
    t.excerpt,
    t.like_count,
    ('https://our_community.com/t/' || t.slug || '/' || t.id) AS url
FROM 
    topics t
JOIN 
    discourse_voting_topic_vote_count dvtv ON t.id = dvtv.topic_id
WHERE 
    t.category_id = 95
AND 
    t.created_at > NOW() - INTERVAL '2 years'
AND deleted_at IS NULL

在 Data & reporting 类别中还有另外几个查询可能对您有用 - Topics tagged topic-voting