1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

--DECLARE @Tag VARCHAR(25) = '##Tag##'

SELECT
  p.Id AS [Post Link],
  p.Score AS [Score],
  p.ViewCount AS [Views],
  p.CreationDate AS [Date]
FROM Posts p
JOIN PostTags 
  ON PostTags.PostId = p.Id
JOIN Tags
  ON Tags.Id = PostTags.TagId  
WHERE p.PostTypeId = 1
  AND p.AnswerCount = 0
  AND p.ClosedDate IS NULL  
  AND p.Tags = ##tag:string##
  AND p.Score >= 0
GROUP BY p.Id, p.Score, p.ViewCount, p.CreationDate
ORDER BY Views DESC

fork query

edited jan 29 23 jraufeisen

created dec 24 14 Gilles