1

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited jun 1

created jun 1 Martin20528