Find duplicated questions which user has answered


Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

SELECT p.parentid, AS [Post Link],
FROM posts p
JOIN posts pp ON p.parentid =
JOIN posthistory ph ON ph.postid =
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

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