Find good questions I didn't answer

0

Please login or register to vote for this query.

(click on this box to dismiss)

Skeptics

Q&A for scientific skepticism

SELECT TOP 10 *
FROM (
  SELECT
    q.ViewCount/(datediff(day, q.CreationDate, GETDATE())) AS DailyViews,
    q.Id AS [Post Link],
    q.Id AS PostId,
    q.ViewCount AS PostViews
  FROM Posts q
  JOIN PostTags pt ON q.Id = pt.PostId
  JOIN Tags t ON pt.TagId = t.Id
  WHERE t.TagName = '##TagName##'
) TopQ
ORDER BY DailyViews DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results