Q&A for users and developers of the Cardano cryptocurrency ecosystem
SELECT TOP ##number?500## Id, url = 'site://q/' + CAST(Id AS varchar), CreationDate, DeletionDate, Score, ViewCount, Tags FROM PostsWithDeleted WHERE (PostTypeId = ##type?1##) and (Deletiondate IS NOT NULL) ORDER BY DeletionDate DESC