0

Please login or register to vote for this query.

(click on this box to dismiss)

Zero and non-zero accepted count. Self-accepted answers do not count.

Q&A about the site for information security professionals

DECLARE @NumberOfRows int = ##NumberOfRows##

SELECT Top ##NumberOfRows##
  Posts.Id AS Id
  , Posts.CreationDate AS CreationDate
  , Posts.Title AS Title
  , Posts.Body As Body
  , 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 jul 17 10 Eric