# 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:** [2016年三月17日 16: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:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Drew\_Warwick](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/drew_warwick/32/80591_2.png) [@Drew\_Warwick](https://meta.discourse.org/u/Drew_Warwick)\
**Post date:** [2016年三月17日 16:56 UTC](https://meta.discourse.org/t/any-way-to-load-more-than-50-search-results-per-query/41213/1 "2016-03-17T16:56:01Z")

</div>

If I search for user:sam and click on “show more”, the full search page only shows 50 results, displaying “No more results found.” afterwards. He’s posted a total of 9716 times (including topics), so 50 is nowhere near close to the total amount. Is there any way to load more posts? The particular reason I’m trying to load more than 50 posts on such a broad query is I want to know how many times a particular user has said a given word and how many times it’s been used over the lifetime over the forum.

---

<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:** [2016年三月17日 17: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'

```

---

<div class="post-metadata">

**Author:** ![Drew\_Warwick](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/drew_warwick/32/80591_2.png) [@Drew\_Warwick](https://meta.discourse.org/u/Drew_Warwick)\
**Post date:** [2016年三月17日 17:26 UTC](https://meta.discourse.org/t/any-way-to-load-more-than-50-search-results-per-query/41213/3 "2016-03-17T17:26:12Z")

</div>

> [@pfaffman](#):
>
> If you have access to the [data explorer](https://meta.discourse.org/t/32566?silent=true) plugin

I’m not an admin on the site I’m trying to find the data for ): So far I’ve been having to stick to sorting by latest and gradually incrementing before:x by the #days the last post in the results was posted ago. Not fun, but I can’t have the world I guess.

---

<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:** [2016年三月17日 17:29 UTC](https://meta.discourse.org/t/any-way-to-load-more-than-50-search-results-per-query/41213/4 "2016-03-17T17:29:06Z")

</div>

In that case, you might automate your search with `wget` or `curl`.

---

<div class="post-metadata">

**Author:** ![Drew\_Warwick](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/drew_warwick/32/80591_2.png) [@Drew\_Warwick](https://meta.discourse.org/u/Drew_Warwick)\
**Post date:** [2016年三月17日 17:37 UTC](https://meta.discourse.org/t/any-way-to-load-more-than-50-search-results-per-query/41213/5 "2016-03-17T17:37:40Z")

</div>

I have no experience with web-based programming, so unfortunately that’s out of my reach right now.

---

<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:** [2016年三月17日 17:52 UTC](https://meta.discourse.org/t/any-way-to-load-more-than-50-search-results-per-query/41213/6 "2016-03-17T17:52:38Z")

</div>

Depending on how many queries you’re doing, it could be worth spending a few minutes to learn one of these tools. Basically, all you do is pass them the URL (the same one you have in your browser) and either of them will pull down the page and let you stick it in a file.

This `curl` command will get each of the past 10 days of times that I used the word “badge” here on meta:

```
curl https://meta.discourse.org/search?q=user:pfaffman+badge+days:[1-10] -o badge_#1.html

```

and put them in files named badge\_#.html (where # gets replaced with the number of days in the query).

If you’re talking about hundreds of queries it might be worth giving that a shot.

OS X includes curl. For Windows, the easiest way is to install [Git](https://git-scm.com/download/win), or see this [stack overflow](http://stackoverflow.com/questions/9507353/how-do-i-install-set-up-and-use-curl-on-a-windows) answer.

Good luck with your sleuthing!

---

<div class="post-metadata">

**Author:** ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)\
**Post date:** [2017年八月2日 23:53 UTC](https://meta.discourse.org/t/any-way-to-load-more-than-50-search-results-per-query/41213/7 "2017-08-02T23:53:11Z")

</div>

Search is now no longer limited to 50 results thanks to @dmacjam !

---

<div class="post-metadata">

**Author:** ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)\
**Post date:** [2017年八月2日 23:53 UTC](https://meta.discourse.org/t/any-way-to-load-more-than-50-search-results-per-query/41213/8 "2017-08-02T23:53:16Z")

</div>


