# Contornando o limite de 10.000 resultados do Data Explorer?

**URL:** https://meta.discourse.org/t/working-around-the-10-000-result-limit-of-data-explorer/315395
**Category:** Data & reporting
**Tags:** data-explorer, sql-query
**Created:** [Junho 26, 2024, 4:11pm UTC](https://meta.discourse.org/t/working-around-the-10-000-result-limit-of-data-explorer/315395 "2024-06-26T16:11:52Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![vladyslav](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/vladyslav/32/366767_2.png) [@vladyslav](https://meta.discourse.org/u/vladyslav)
#### Post date: [Junho 26, 2024, 4:11pm UTC](https://meta.discourse.org/t/working-around-the-10-000-result-limit-of-data-explorer/315395/1 "2024-06-26T16:11:52Z")

</div>

> [@Discourse](#):
>
> Os dados baixados de uma consulta em formato JSON ou CSV terão um limite de resultados muito maior de 10.000 linhas.

Existe alguma maneira de contornar esse limite? Eu quero baixar todos os tópicos não listados, e há muitos deles. Muito mais do que 10 mil.

---

<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: [Junho 26, 2024, 4:29pm UTC](https://meta.discourse.org/t/working-around-the-10-000-result-limit-of-data-explorer/315395/2 "2024-06-26T16:29:17Z")

</div>

Para consultas maiores, você pode adicionar paginação a elas e obter lotes que podem ser mesclados ‘fora do local’. Algo como:

```sql
--[params]
-- integer :limit = 10000
-- integer :page = 0

SELECT
    id,
    title
FROM topics
WHERE visible = false
ORDER BY id
OFFSET :page * :limit
LIMIT :limit

```

---

<div class="post-metadata">

### Author: ![vladyslav](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/vladyslav/32/366767_2.png) [@vladyslav](https://meta.discourse.org/u/vladyslav)
#### Post date: [Junho 26, 2024, 5:49pm UTC](https://meta.discourse.org/t/working-around-the-10-000-result-limit-of-data-explorer/315395/3 "2024-06-26T17:49:44Z")

</div>

Incrível, obrigado 🙌  
Funcionou. Eu só não sabia como funcionava a paginação em SQL.

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [Maio 12, 2025, 11:37pm UTC](https://meta.discourse.org/t/working-around-the-10-000-result-limit-of-data-explorer/315395/4 "2025-05-12T23:37:30Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.