Q&A about the site for linguists, teachers and students of the Ukrainian language
SELECT TOP(##num?250##) Id, DATEDIFF(day, CreationDate, DeletionDate), Score, url = 'site://q/' + CAST(Id AS varchar) FROM PostsWithDeleted WHERE (DATEDIFF(day, CreationDate, DeletionDate)>=##days?1095##) AND (Score>=##minscore?5##) AND (PostTypeId=1) ORDER BY DATEDIFF(day, CreationDate, DeletionDate) DESC --PosttypeId=1 questions --PosttypeId=2 answers