# Get list of topics pinned globally

**URL:** <https://meta.discourse.org/t/get-list-of-topics-pinned-globally/68972>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [8월 29, 2017, 7:41오전 UTC](https://meta.discourse.org/t/get-list-of-topics-pinned-globally/68972 "2017-08-29T07:41:55Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![adopilot](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/adopilot/32/105040_2.png) [@adopilot](https://meta.discourse.org/u/adopilot)\
**Post date:** [8월 29, 2017, 12:27오후 UTC](https://meta.discourse.org/t/get-list-of-topics-pinned-globally/68972/5 "2017-08-29T12:27:04Z")

</div>

Thanx for tip here is corrected version for others.  
Added pinned\_globally=TRUE in where clue

`SELECT id, title, user, category_id ,pinned_globally FROM topics WHERE pinned_at IS NOT NULL and pinned_globally=TRUE`

`{"query":{"id":12,"sql":"SELECT id, title, user, category_id ,pinned_globally FROM topics WHERE pinned_at IS NOT NULL and pinned_globally=TRUE","name":"Pinned Topics","description":"Enter a description here","param_info":[]}}`

---

_[View the full topic](https://meta.discourse.org/t/get-list-of-topics-pinned-globally/68972)._