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.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 CommentCount >1
  AND AnswerCount >1
  AND FavoriteCount >1
  
ORDER BY
  Views DESC

fork query

edited nov 16 anonymous

created jul 17 10 Eric