# Most clicked external links?

**URL:** https://meta.discourse.org/t/most-clicked-external-links/127742
**Category:** Development
**Created:** [September 5, 2019, 9:29pm UTC](https://meta.discourse.org/t/most-clicked-external-links/127742 "2019-09-05T21:29:27Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![Remah](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/remah/32/70590_2.png) [@Remah](https://meta.discourse.org/u/Remah)
#### Post date: [September 6, 2019, 10:47am UTC](https://meta.discourse.org/t/most-clicked-external-links/127742/2 "2019-09-06T10:47:26Z")

</div>

I searched for “click count” and found this query for the most clicked outgoing clicks:

> [@Aggregated click number on forum click counter](https://meta.discourse.org/t/aggregated-click-number-on-forum-click-counter/26846/5):
>
> I believe what you’re interested in is the topic\_links table (in /db/structure.sql) CREATE TABLE topic\_links ( id integer NOT NULL, topic\_id integer NOT NULL, post\_id integer, user\_id integer NOT NULL, url character varying(500) NOT NULL, domain character varying(100) NOT NULL, internal boolean DEFAULT false NOT NULL, link\_topic\_id integer, created\_at timestamp without time zone NOT NULL, updated\_at timestamp without time zone NOT NULL, reflection boo…

---

_[View the full topic](https://meta.discourse.org/t/most-clicked-external-links/127742)._