Posts by a deleted user

1

Please login or register to vote for this query.

(click on this box to dismiss)

Politics Meta

Q&A about the site for people interested in governments, policies, and political processes

SELECT p.Id As [Post Link], 
  p.CreationDate, p.Score, 
CASE p.PostTypeId
    WHEN 1 THEN 'Question'
    WHEN 2 THEN 'Answer'
  END,
  q.Tags, q.ViewCount, q.Title
FROM Posts q INNER JOIN Posts p ON coalesce(p.ParentId, p.Id)=q.Id 
WHERE (p.OwnerDisplayName='user' + Convert(nvarchar(20), ##UserId##))
  AND (q.PostTypeId=1)

Enter Parameters

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