Lists all questions I have proposed an answer to, and, sadly, the original asker accepted a different answer.
Q&A for those who create, solve, and study puzzles
-- Questions I have answered where asker has not accepted an answer -- Lists all questions I have proposed an answer to, but the original question asker hasn't accepted an answer SELECT p.Id AS [Post Link], p.AnswerCount, a.Score FROM Posts a, Posts p WHERE a.OwnerUserId = ##UserId## AND a.PostTypeId = 2 AND p.AcceptedAnswerId IS NOT NULL AND p.Id = a.ParentId ORDER BY a.Score DESC