# Common Discourse data tips

**URL:** <https://meta.discourse.org/t/common-discourse-data-tips/276148>\
**Category:** Data & reporting\
**Tags:** sql-tutorial\
**Created:** [August 22, 2023, 8:12am UTC](https://meta.discourse.org/t/common-discourse-data-tips/276148 "2023-08-22T08:12:50Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)\
**Post date:** [August 22, 2023, 11:34am UTC](https://meta.discourse.org/t/common-discourse-data-tips/276148/3 "2023-08-22T11:34:25Z")

</div>

I don’t think so? It’s meant to convey that posts which are in deleted topics aren’t included. Using messages makes it sound like it’s referring to PMs. But I’ll have another look at how to describe it more clearly. 👍

* * *

Another thought -

Including `AND p.post_type = 1` may be a good inclusion for this one as well. 🤔

---

_[View the full topic](https://meta.discourse.org/t/common-discourse-data-tips/276148)._