# Stats on theme utilisation

**URL:** https://meta.discourse.org/t/stats-on-theme-utilisation/249187
**Category:** Support
**Created:** [December 16, 2022, 8:57pm UTC](https://meta.discourse.org/t/stats-on-theme-utilisation/249187 "2022-12-16T20:57:44Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [December 16, 2022, 9:23pm UTC](https://meta.discourse.org/t/stats-on-theme-utilisation/249187/3 "2022-12-16T21:23:43Z")

</div>

See also

> [@Is there any way of telling how popular a Theme is?](https://meta.discourse.org/t/is-there-any-way-of-telling-how-popular-a-theme-is/93796/4):
>
> You don’t really need to look at the users table here to display usernames. [Data Explorer](https://meta.discourse.org/t/32566?silent=true) will automatically display avatars and username if the result of your query has a user\_id column which the user\_options table does have. slight_smile Anyway, this topic got me personally interested so I spent a few minutes playing with [data explorer](https://meta.discourse.org/t/32566?silent=true) and I got this little query which shows you user-selectable themes with the number of users using each theme: WITH theme\_stats AS ( SELECT theme\_ids[1]…

---

_[View the full topic](https://meta.discourse.org/t/stats-on-theme-utilisation/249187)._