# Data discrepancy in user post counts

**URL:** <https://meta.discourse.org/t/data-discrepancy-in-user-post-counts/177214>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [January 25, 2021, 8:14pm UTC](https://meta.discourse.org/t/data-discrepancy-in-user-post-counts/177214 "2021-01-25T20:14:16Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![JusticeUK](https://avatars.discourse-cdn.com/v4/letter/j/8e8cbc/32.png) [@JusticeUK](https://meta.discourse.org/u/JusticeUK)\
**Post date:** [January 26, 2021, 12:02am UTC](https://meta.discourse.org/t/data-discrepancy-in-user-post-counts/177214/2 "2021-01-26T00:02:13Z")

</div>

Hi Holly, the table posts will also include private messages and deleted posts. Maybe user\_stats.post\_count only includes undeleted posts, and not private messages and deleted posts? Someone with more knowledge can hopefully answer.

---

_[View the full topic](https://meta.discourse.org/t/data-discrepancy-in-user-post-counts/177214)._