Get all posts by user

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフロー

プログラマーとプログラミングに熱心な人々のための質問と回答

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

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