# 如何判断一个主题的受欢迎程度？

**URL:** <https://meta.discourse.org/t/is-there-any-way-of-telling-how-popular-a-theme-is/93796>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [2018 年8 月 2 日 19:11 UTC](https://meta.discourse.org/t/is-there-any-way-of-telling-how-popular-a-theme-is/93796 "2018-08-02T19:11:10Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

作者： ![merefield](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/merefield/32/176214_2.png) [@merefield](https://meta.discourse.org/u/merefield)\
发布日期： [2018 年8 月 2 日 20:08 UTC](https://meta.discourse.org/t/is-there-any-way-of-telling-how-popular-a-theme-is/93796/3 "2018-08-02T20:08:56Z")

</div>

Yep, ok, thanks!

So here’s what I’ve got now with some more exploration.

Seems like current default theme is stored in user options field theme\_ids which is an ARRAY … and in the 1th element, so theme\_ids[1].

`select u.username, t.id, t.name from users u inner join user_options o on u.id = o.user_id inner join themes t on o.theme_ids[1] = t.id where theme_ids[1] <> 0`

In my case it’s not even worth grouping and counting because generally users don’t seem to have selected a different default theme to the default, default one - it comes back with two users (out of a regular bunch of 300!), and one of them is … ME! 😃 :

I guess the issue is you can’t see what users have set on their local, by device, settings?

---

_[View the full topic](https://meta.discourse.org/t/is-there-any-way-of-telling-how-popular-a-theme-is/93796)._