Anton.Sandbox

1

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

-- Popular questions requiring answers
-- Users coming from search engines

select top 25
Id as [Post Link],
datediff(d, CreationDate, getdate()) as AgeDays,
Score, ViewCount, AnswerCount,
ViewCount / (AnswerCount + 1) as Views2Answers
--( ViewCount / AgeDays ) as ViewsPerDay
from Posts
where
  PostTypeId = 1 and
--  AcceptedAnswerId is null and
  ClosedDate is null and
  CommunityOwnedDate is null
--  and CreationDate > '2017-02-01'
  and AnswerCount = 0
  and datediff(d, CreationDate, getdate()) < 700
order by ViewCount desc

Enter Parameters

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