# 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:** 3
**Page:** 1
### Author:  [@olegbc1](https://meta.discourse.org/u/olegbc1)
#### Post date: [September 5, 2019, 9:29pm UTC](https://meta.discourse.org/t/most-clicked-external-links/127742/1 "2019-09-05T21:29:27Z")
I want to put together a list of most clicked external links that we have on our forum. Which table/column in discourse database has the count that I can pull from? Thanks!
---
### Author:  [@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")
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…
---
### Author:  [@olegbc1](https://meta.discourse.org/u/olegbc1)
#### Post date: [September 6, 2019, 4:02pm UTC](https://meta.discourse.org/t/most-clicked-external-links/127742/3 "2019-09-06T16:02:13Z")
That was it! Thank you so much