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

**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:** 2

<div class="post-metadata">

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

</div>

Well, using LEFT JOIN might be returning a lot of NULL fields in the results. Try changing those to simple JOIN instead (INNER JOIN is the Postgres default for JOIN)

---

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