Select questions of a given age, with no answer and a descent score

0

Please login or register to vote for this query.

(click on this box to dismiss)

LEGO® Answers Meta

Q&A about the site for LEGO® and building block enthusiasts

select
  p.id as [Post Link],
  title,
  p.tags as Tags,
  p.ViewCount as "Views", 
  p.score as "Score", 
  p.AnswerCount as "Answers", 
  DATEDIFF(day,p.CreationDate,getdate()) as "Age (days)",
  p.AcceptedAnswerId as "Answer Accepted?"

from posts p

where

  p.AnswerCount = 0 and
  DATEDIFF(day,p.CreationDate,getdate()) < ##maxage:int?120## and
  DATEDIFF(day,p.CreationDate,getdate()) > ##minage:int?20## and
  p.score > ##minscore:int?5## 
  

order by p.score desc, p.viewcount desc;

Enter Parameters

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