Hi all! I’m using the Data Explorer plugin and attempting to get topics within our Feedback category - I can achieve this fine with the following query: SELECT t.id AS topic_id, t.title AS topic_title, t.excerpt, t.like_count, ('https://our_community.com/t/' || t.slug || '/' || t.id) AS url FROM topics t WHERE t.category_id = 95 AND t.created_at > NOW() - INTERVAL '2 years' AND deleted_at IS NULL What I am unsure of is how to also include the vote count associated Topic Voting plugin. Does anyone know how I might include that for each post in the query above?

The Topic Voting tables are discourse_voting_topic_votes and discourse_voting_votes. You can include the number of votes for each topic with something like this: :+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 There are also a couple more queries you may find useful in the #data-reporting category - Topics tagged topic-voting

Data Explorer - ספירת הצבעות

קהילה נתונים ודיווח

tyf (Ty Frith) 28 במאי,‏ 2023,‏ 3:58pm 3

Thanks @JammyDodger !

נושא		תגובות	צפיות
A summary of votes by topic, including tags Data & reporting topic-voting , sql-query	5	468	31 בינואר,‏ 2023
Show total votes next to total replies, views and activity columns Feature topic-voting	10	3352	18 בדצמבר,‏ 2025
Show votes in post list "totals" columns Feature topic-voting	2	2698	6 באפריל,‏ 2019
Topic List Voting Column Theme component topic-voting	0	194	18 בדצמבר,‏ 2025
Number of topics in a category Product Support	5	1164	20 בספטמבר,‏ 2020

Data Explorer - ספירת הצבעות

נושאים קשורים