# Data Explorer - Query to determine user theme preferences

**URL:** https://meta.discourse.org/t/data-explorer-query-to-determine-user-theme-preferences/106718
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [January 16, 2019, 5:55pm UTC](https://meta.discourse.org/t/data-explorer-query-to-determine-user-theme-preferences/106718 "2019-01-16T17:55:37Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![Johani](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/johani/32/176920_2.png) [@Johani](https://meta.discourse.org/u/Johani)
#### Post date: [January 16, 2019, 6:03pm UTC](https://meta.discourse.org/t/data-explorer-query-to-determine-user-theme-preferences/106718/2 "2019-01-16T18:03:28Z")

</div>

I believe @osama has already created a query that allows you to check a theme’s popularity. Have a look here

> [@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/data-explorer-query-to-determine-user-theme-preferences/106718)._