Answers by a user that have been merged to a different question

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT p.Id AS [Post Link]
FROM Posts p, PostHistory ph
WHERE p.PostTypeId = 2                   -- is an answer
      AND ph.PostId = p.Id
      AND ph.PostHistoryTypeId IN (38)   -- has a merge destination
      AND p.OwnerUserId = ##userId##
ORDER BY p.Id ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results