Get all posts by user


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 Self.Title, Self.ParentId, Parent.Title, Self.Body 
FROM Posts AS Self, Posts AS Parent, Users 
WHERE Self.OwnerUserId=Users.Id 
AND (Self.ParentId = Parent.Id OR Parent.Id=0)
AND Users.Id=##UserId##

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results