Number of posts on topics where poster is not the author?

[SidV]

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 know that their messages are five with data explorer?
I mean I need an SQL query that returns the number of user messages on topics where he is not the author.

I was looking for the query, I checked the list of queries’s Data Explorer, and I also tried to create a new query to get the result, however I can not find how many posts a user has.

My head has burned, excuse me.

I hope someone can help me

[david (David Taylor)]

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 IS NULL
AND topics.archetype = 'regular'

[SidV]

Just GREAT !

Thanks @david !

Solved! (list updated)