select 'site://q/' + CONVERT(nvarchar(20), pwd.id) AS [Li...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select 
  'site://q/' + CONVERT(nvarchar(20), pwd.id) AS [Link],
  pwd.CreationDate,
  pwd.DeletionDate,
  pwd.Score,
  pwd.ClosedDate
from PostsWithDeleted pwd
inner join votes v on v.postid = pwd.id and v.votetypeid = 12
order by v.creationdate desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results