# User Summary - Most Liked By user attributions are incorrect

**URL:** <https://meta.discourse.org/t/user-summary-most-liked-by-user-attributions-are-incorrect/42668>\
**Category:** Bug\
**Created:** [4월 16, 2016, 8:07오후 UTC](https://meta.discourse.org/t/user-summary-most-liked-by-user-attributions-are-incorrect/42668 "2016-04-16T20:07:30Z")\
**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:** [4월 16, 2016, 9:43오후 UTC](https://meta.discourse.org/t/user-summary-most-liked-by-user-attributions-are-incorrect/42668/5 "2016-04-16T21:43:05Z")

</div>

> [@Yuun](#):
>
> I’m using the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) query detailed here as my main comparison

AFAICT that query doesn’t take into consideration Likes that were given, then taken back (or otherwise negated).  
If you run

```sql
SELECT *
FROM post_actions
WHERE post_action_type_id = 2
AND user_id = deleted_by_id

```

does the difference in the count jive?

---

_[View the full topic](https://meta.discourse.org/t/user-summary-most-liked-by-user-attributions-are-incorrect/42668)._