# User posts export as csv or text

**URL:** <https://meta.discourse.org/t/user-posts-export-as-csv-or-text/273232>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [July 29, 2023, 3:34pm UTC](https://meta.discourse.org/t/user-posts-export-as-csv-or-text/273232 "2023-07-29T15:34:26Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![kynic](https://avatars.discourse-cdn.com/v4/letter/k/b487fb/32.png) [@kynic](https://meta.discourse.org/u/kynic)\
**Post date:** [July 29, 2023, 4:13pm UTC](https://meta.discourse.org/t/user-posts-export-as-csv-or-text/273232/2 "2023-07-29T16:13:57Z")

</div>

I found this code works for [data explorer](https://meta.discourse.org/t/32566?silent=true)

```plaintext
SELECT t.title, p.raw as text, p.created_at as dateposted
FROM posts p
LEFT JOIN topics t ON t.id = p.topic_id
WHERE t.archetype != 'private_message'
AND t.user_id = 1
AND p.user_id = 1
AND t.category_id IN (13,7,1,)
AND t.deleted_at is null

```

But it only shows 336 results is there any way to pass this limit? as there are around 5k posts.

---

_[View the full topic](https://meta.discourse.org/t/user-posts-export-as-csv-or-text/273232)._