olegbc1
September 5, 2019, 9:29pm
1
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!
Remah
September 6, 2019, 10:47am
2
I searched for “click count” and found this query for the most clicked outgoing clicks:
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…
3 Likes
olegbc1
September 6, 2019, 4:02pm
3
That was it! Thank you so much