Posts by a deleted user

1

Please login or register to vote for this query.

(click on this box to dismiss)

Programming Language Design and Implementation

Q&A for designers and implementers of computer programming languages

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 meta site
loading Hold tight while we fetch your results