0

Please login or register to vote for this query.

(click on this box to dismiss)

How many questions per month does each tag in the top 10 tags get

Q&A for pro webmasters

DECLARE @NumberOfRows int = ##NumberOfRows##

SELECT Top ##NumberOfRows##
  Posts.Id AS Id
  , Posts.CreationDate AS CreationDate
  , Posts.Title AS Title
  , Posts.Score AS Score
  , Posts.ViewCount AS Views
  , Posts.AnswerCount AS AnswerCount
  , Posts.CommentCount AS CommentCount
  , Posts.FavoriteCount AS FavoriteCount
  , Posts.Tags AS Tags
  
FROM
  Tags
  JOIN PostTags ON PostTags.TagId = Tags.Id
  JOIN Posts ON Posts.Id = PostTags.PostId
  
WHERE
  Tags.TagName COLLATE SQL_Latin1_General_CP1_CI_AS LIKE ##EnterKeyword:string##
  AND Posts.PostTypeId = 1
  AND Posts.CommentCount >10
  AND Posts.AnswerCount >10
  
ORDER BY
  Views DESC

fork query

edited nov 16 anonymous

created jan 16 12 sam.saffron