Q&A for SharePoint enthusiasts
SELECT p.OwnerUserId, p.OwnerUserId AS [User Link], p.OwnerDisplayname, p.Id AS [Post Link], p.CreationDate FROM Posts p WHERE p.OwnerUserId=##userid## ORDER BY p.Id DESC