SELECT COUNT(*) AS 'Total count' FROM Posts p, PostTags p...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT COUNT(*) AS 'Total count'
FROM Posts p, PostTags pt, Tags t
WHERE p.Id=pt.PostId
AND pt.TagId=t.Id
AND t.TagName=##tag:string##
AND p.ParentId IS NULL
--AND ClosedDate IS NOT NULL

Enter Parameters

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