Unanswered recently upvoted questions in tag

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

SELECT TOP ##top##
  v.PostId as [Post Link],
  p.Score,
  p.AnswerCount
FROM 
  Votes v 
  JOIN Posts p ON p.Id = v.PostId
  JOIN PostTags pt ON pt.PostId = v.PostId
  JOIN Tags t ON t.Id = pt.TagId
WHERE v.VoteTypeId = 2
  AND v.CreationDate >= DATEADD(day, -##days##, GETDATE())
  AND p.PostTypeId = 1
  AND p.AnswerCount <= 1
  AND p.ClosedDate IS NULL
  AND p.AcceptedAnswerId IS NULL
  AND t.TagName = '##tag##'

Enter Parameters

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