0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

select p.id, p.title
from posts p
inner join PostHistory ph on ph.postid = p.id 
where p.posttypeid = 1 -- q
and ph.PostHistoryTypeId = 10 -- closed
and ph.comment = 101 -- as duplicate

fork query

edited oct 24 19 anonymous

created jan 24 14 jon.doe6935