# 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:** [2017 年 8 月 29 日午前 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:** 1

<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:** [2017 年 8 月 29 日午前 7:41 UTC](https://meta.discourse.org/t/get-list-of-topics-pinned-globally/68972/1 "2017-08-29T07:41:55Z")

</div>

Is there a way to get list of topics which are pinned globally.

In advanced search there is “are pinned” but it does list all pined topics.

 ![image](https://global.discourse-cdn.com/meta/original/3X/e/d/ed7636c52941021142460bd07a95a1fc138d6f03.png)

We wold like to find globally pined topics so we can clear our latest list.

---

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