Let’s suppose the following: A user creates a new discussion and responds 2 (two) times to his topic. At the same time, the same user in other topics that other people published, responds with five messages. The user’s “posts” counter shows his messages (which would be two plus five). How do I kn…

The number of posts by a user on topics where the user is not the OP: -- [params] -- string :user_id = 3 SELECT count(posts.id) FROM posts JOIN topics ON topics.id = posts.topic_id WHERE posts.user_id = :user_id AND NOT topics.user_id = :user_id AND posts.deleted_at IS NULL AND topics.deleted_at I…

:clap: :clap: :clap: :clap: Just GREAT ! Thanks @david ! Solved! :rocket: (list updated)

非作者发布的主题帖子数量？

社区数据与报告

SidV 2018 年12 月 17 日 17:32 3

Just GREAT !

Thanks @david !

Solved! (list updated)

话题		回复	浏览量
Data discrepancy in user post counts Data & reporting sql-query	3	640	2021 年1 月 26 日
Any way to see how many posts a user has made in a topic with more than 10,000 posts? Support	1	610	2022 年2 月 10 日
Common Discourse data tips Data & reporting sql-tutorial	3	542	2023 年8 月 22 日
How many users have posted at least one topic? Feature	1	787	2017 年1 月 5 日
Finding unread posts for a user Support	2	394	2022 年12 月 12 日

非作者发布的主题帖子数量？

相关话题