Q&A about the site for Tridion developers and administrators
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;