questions + views for tags on serverfault

0

Please login or register to vote for this query.

(click on this box to dismiss)

GenAI Meta

Q&A for GenAI enthusiasts and practitioners and those interested in learning more about using GenAI tools

-- questions + views for tags on serverfault
-- Enter Query Description

-- find number of questions for a list of tags
-- given a list of tags find out how many question each of the tags has

select Tags.Tagname, count(Posts.Id) as questions, sum(ViewCount) as views from Posts left join
  PostTags on PostS.Id = PostTags.PostId left Join
  Tags on PostTags.TagId = Tags.Id
where
  Tags.TagName in (

-- enter tags here

'Asterisk','Asterisknow','Voip','SIP','PBX','Trixbox','Telephony','Freepbx','Pbxt','Telephony','SMS','SSMS2008','SMS-Gateway','agi','ivr','tts','fastagi','adhearsion','twilio','tropo','telephony','kannel','smpp'
)
group by Tags.TagName

Enter Parameters

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