0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Ubuntu users and developers

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?200##


order by p.viewcount desc;

fork query

edited jun 23 18 anonymous

created may 19 16 karann