点击最多的外部链接？

[olegbc1 (OlegBC)]

我想整理一份我们论坛上点击次数最多的外部链接列表。Discourse 数据库中的哪张表或哪一列包含我可以提取的计数？谢谢！

[Remah (Just another happy Discourse user)]

我搜索了“点击次数”，并找到了这个关于论坛点击计数器中最常被点击的外部链接的查询：

Aggregated click number on forum click counter

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…

[olegbc1 (OlegBC)]

就是这样！非常感谢！