Sample for 9068932

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

SELECT 
p.ID [Post Link],
Count(c.id) comment_count
FROM
comments c
RIGHT JOIN posts p
on c.postId =p.id
WHERE 
p.OwnerUserID = 762082 --Just Tandy's posts
GROUP BY
p.ID

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results