Q&A about the site for professional linguists and others with an interest in linguistic research and theory
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