Count number of questions, answers and comments on a tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackoverflow.com/q/316413

Amateur Radio

Q&A for amateur radio enthusiasts

select * --sum( case when posttypeid = 1 then 1 else null end)  [Questions]
     --, sum( case when posttypeid = 2 then 1 else null end)  [Answers]
    -- , sum( case when posttypeid  in (1,2) then 1 else null end)  [Total]

from posts p
inner join posttags pt on pt.postid = coalesce(p.parentid, p.id)
inner join tags t on t.id = pt.tagid
where tagname = ##tag1:string## collate SQL_Latin1_General_CP1_CI_AI

Enter Parameters

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