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 17 ديسمبر 2018، 5:32م 3

Just GREAT !

Thanks @david !

Solved! (list updated)

الموضوع		الردود	مرات العرض
Data discrepancy in user post counts Data & reporting sql-query	3	640	26 يناير 2021
Any way to see how many posts a user has made in a topic with more than 10,000 posts? Support	1	610	10 فبراير 2022
Common Discourse data tips Data & reporting sql-tutorial	3	542	22 أغسطس 2023
How many users have posted at least one topic? Feature	1	787	5 يناير 2017
Finding unread posts for a user Support	2	394	12 ديسمبر 2022

عدد المنشورات في المواضيع حيث الناشر ليس المؤلف؟

الموضوعات ذات الصلة