# Why have I not yet received the EMPATHETIC badge on my site?

**URL:** <https://meta.discourse.org/t/why-have-i-not-yet-received-the-empathetic-badge-on-my-site/49425>\
**Category:** Product Support\
**Created:** [30 Agosto 2016, 3:43am UTC](https://meta.discourse.org/t/why-have-i-not-yet-received-the-empathetic-badge-on-my-site/49425 "2016-08-30T03:43:54Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Mittineague](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mittineague/32/114259_2.png) [@Mittineague](https://meta.discourse.org/u/Mittineague)\
**Post date:** [30 Agosto 2016, 4:46am UTC](https://meta.discourse.org/t/why-have-i-not-yet-received-the-empathetic-badge-on-my-site/49425/5 "2016-08-30T04:46:12Z")

</div>

> [@tobiaseigen](#):
>
> easy way to determine the number of different posts that have been liked?

> [@jomaxro](#):
>
> [Data explorer](https://meta.discourse.org/t/32566?silent=true)? Would need to write up some SQL…

lol I just did out of curiosity.

I was a bit surprised the badge query uses the posts table instead of the badge\_posts view.

Anyway, try this  
(you’ll need to know your id number)

```plaintext
-- [params] 
-- int :the_user_id = 2

SELECT COUNT(posts.like_count) AS liked_posts 
FROM posts 
WHERE posts.user_id = :the_user_id 
AND posts.like_count > 0

```

---

_[View the full topic](https://meta.discourse.org/t/why-have-i-not-yet-received-the-empathetic-badge-on-my-site/49425)._