# Any way to load more than 50 search results per query?

**URL:** https://meta.discourse.org/t/any-way-to-load-more-than-50-search-results-per-query/41213
**Category:** Support
**Created:** [3월 17, 2016, 4:56오후 UTC](https://meta.discourse.org/t/any-way-to-load-more-than-50-search-results-per-query/41213 "2016-03-17T16:56:01Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [3월 17, 2016, 5:20오후 UTC](https://meta.discourse.org/t/any-way-to-load-more-than-50-search-results-per-query/41213/2 "2016-03-17T17:20:04Z")

</div>

No. You can’t get more than 50:

> [@Search Results Limited to 50 each time](https://meta.discourse.org/t/search-results-limited-to-50-each-time/34270/2):
>
> It’s the undocumented design, not easy to solve

If you have access to the [data explorer plugin](https://github.com/discourse/discourse-data-explorer) you can do a search like this to get all posts with the word:

```plaintext
SELECT p.id as post_id, user_id, topic_id from posts p
JOIN users u on u.id=user_id
where p.raw like '%WORD%'

```

and this to get them just for the user:

```plaintext
SELECT p.id as post_id, user_id, topic_id from posts p
JOIN users u on u.id=user_id
where p.raw like '%WORD%'
AND u.username='USERNAME'

```

---

_[View the full topic](https://meta.discourse.org/t/any-way-to-load-more-than-50-search-results-per-query/41213)._