Find duplicated questions which user has answered

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT p.parentid,
       p.id AS [Post Link],
       p.title,
       pp.title
FROM posts p
JOIN posts pp ON p.parentid = pp.id
JOIN posthistory ph ON ph.postid = pp.id
WHERE p.posttypeid = 2 -- answer
AND p.owneruserid = ##userid##
  AND ph.posthistorytypeid = 10 -- closed
AND ph.comment = 101 -- as duplicate
AND pp.closeddate IS NOT NULL

Enter Parameters

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