# Finding list of shared links

**URL:** https://meta.discourse.org/t/finding-list-of-shared-links/116717
**Category:** Feature
**Created:** [May 2, 2019, 8:44pm UTC](https://meta.discourse.org/t/finding-list-of-shared-links/116717 "2019-05-02T20:44:33Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![jesselperry](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jesselperry/32/119501_2.png) [@jesselperry](https://meta.discourse.org/u/jesselperry)
#### Post date: [May 2, 2019, 8:44pm UTC](https://meta.discourse.org/t/finding-list-of-shared-links/116717/1 "2019-05-02T20:44:33Z")

</div>

Hi all,

Is there a feature/report I’m unaware of that would allow me to easily see all the outbound links included in posts on my Discourse?

Thanks!

---

<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: [May 2, 2019, 9:23pm UTC](https://meta.discourse.org/t/finding-list-of-shared-links/116717/2 "2019-05-02T21:23:28Z")

</div>

If you have [data explorer](https://meta.discourse.org/t/32566?silent=true), something like this might work:

```sql
SELECT topic_id, post_id, user_id, url, clicks, created_at
from topic_links
where user_id > 1
and url like 'http%'
and URL not like '%myforum.com%'
order by created_at desc

```

---

<div class="post-metadata">

### Author: ![simon](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/simon/32/339122_2.png) [@simon](https://meta.discourse.org/u/simon)
#### Post date: [May 2, 2019, 10:24pm UTC](https://meta.discourse.org/t/finding-list-of-shared-links/116717/3 "2019-05-02T22:24:09Z")

</div>

You can use the value of the `internal` field to check for external links.

```sql
SELECT topic_id, post_id, user_id, url, created_at
FROM topic_links
WHERE internal = false
    AND user_id > 0

```