The bottom of the barrell

0

Please login or register to vote for this query.

(click on this box to dismiss)

Home Improvement

Q&A for contractors and serious DIYers

SELECT TOP 500
  PostsWithDeleted.Id,
  PostTypes.Name,
  PostsWithDeleted.CreationDate,
  PostsWithDeleted.DeletionDate,
  PostsWithDeleted.Score,
  'site://q/'+cast(PostsWithDeleted.Id as varchar)
FROM PostsWithDeleted
JOIN PostTypes on PostTypes.Id = PostsWithDeleted.PostTypeId
ORDER BY PostsWithDeleted.Score

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results