# 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:** 4

<div class="post-metadata">

**Author:** ![hollyw](https://avatars.discourse-cdn.com/v4/letter/h/4da419/32.png) [@hollyw](https://meta.discourse.org/u/hollyw)\
**Post date:** [January 26, 2021, 2:41pm UTC](https://meta.discourse.org/t/data-discrepancy-in-user-post-counts/177214/4 "2021-01-26T14:41:12Z")

</div>

Thanks for the info. However, this user has no deleted posts (I double checked their profile and added a `p.deleted_at is null` to my above query and am still seeing the same numbers. Our forum also has PM’s disabled, so I don’t think those would be messing with the numbers.

When looking at this user’s posts, they are all `post_type = 1`. I don’t know what exactly a `post_type` of 1 means yet, but all of his just seem to be normal posts.

---

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