List of posts flagged as spam (refactored, but still times out)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

SELECT  
  -- p.Id AS [Post Link]
  concat(
  'site://q/'
  , p.id
  , '|'
  , case when p.posttypeid = 1 then 'Q ' else 'A ' 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

Enter Parameters

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