# Query for Current Vote Count

**URL:** <https://meta.discourse.org/t/query-for-current-vote-count/240985>\
**Category:** Data & reporting\
**Tags:** topic-voting, sql-query\
**Created:** [November 19, 2021, 11:54am UTC](https://meta.discourse.org/t/query-for-current-vote-count/240985 "2021-11-19T11:54:04Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)\
**Post date:** [November 20, 2021, 6:52am UTC](https://meta.discourse.org/t/query-for-current-vote-count/240985/4 "2021-11-20T06:52:42Z")

</div>

> [@icaria36](#):
>
> PERFECT! Thank you so much! For the script and the little SQL lesson. I hope this was useful for you too.

I’m really pleased it worked. 👍 I’ve been wanting to practice with the [data explorer](https://meta.discourse.org/t/32566?silent=true) for awhile and this seemed like a perfect opportunity, so really I should be thanking you. 🙂

> [@icaria36](#):
>
> I bet this query will be useful to others. In our case, we want to show this distribution of votes so that our volunteers can be more self-aware about how much / how little use they are doing of their votes compared to other peers. The ultimate goal being to increase the number of votes used.

I added in the ‘archive = false’ line to restrict the results to a user’s current vote count total, and not include historic ones. I think that’s right for your use case, but remove it if you want a ‘grand total’.

Thanks again. 👍🙂

---

_[View the full topic](https://meta.discourse.org/t/query-for-current-vote-count/240985)._
