Total comment count with a tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

DECLARE @from_date AS date = '##FromDate##'
DECLARE @to_date AS date = '##ToDate##'
SELECT SUM(CAST(CommentCount AS BIGINT)) AS comment_count FROM Posts
WHERE PostTypeId = 1 AND CreationDate > @from_date AND CreationDate < @to_date AND Tags LIKE '%##Tag##%'

Enter Parameters

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