# Data mining a Discourse site for links

**URL:** <https://meta.discourse.org/t/data-mining-a-discourse-site-for-links/34943>\
**Category:** Feature\
**Created:** [October 26, 2015, 10:59pm UTC](https://meta.discourse.org/t/data-mining-a-discourse-site-for-links/34943 "2015-10-26T22:59:39Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![riking](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/riking/32/170938_2.png) [@riking](https://meta.discourse.org/u/riking)\
**Post date:** [October 27, 2015, 3:41am UTC](https://meta.discourse.org/t/data-mining-a-discourse-site-for-links/34943/6 "2015-10-27T03:41:39Z")

</div>

```plaintext
{"query":{"id":10,"sql":"SELECT url, count(*)\nFROM topic_links\nGROUP BY url\nORDER BY count DESC","name":"All outbound links","description":"Use the \"Download Results\" button to get it as a file.","param_info":[]}}

```

Import that, Run Query, then Click the “Download Results CSV” button.

---

_[View the full topic](https://meta.discourse.org/t/data-mining-a-discourse-site-for-links/34943)._