0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT  
  -- p.Id AS [Post Link]
  concat(
  'site://q/'
  , p.id
  , '|'
  , case when p.posttypeid = 1 then 'Q ' else null  end
  , case when p.posttypeid = 1 then isnull(title, 'deleted')  else 'Answer to ' end
  , case when p.posttypeid = 2 then parentid else null end
  ) [Link To SpamFlagged posts]
 
FROM Votes v INNER JOIN PostsWithDeleted p ON v.PostId=p.Id
WHERE v.VoteTypeId=12
ORDER BY p.Id ASC

fork query

edited nov 24 rene

created sep 7 Martin20528