Duplicate posts and their originals

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stellar Meta

Q&A about the site for developers and users of Stellar and the Stellar Distributed Exchange

select *
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

--select * from Posts where LastEditorUserId=100297


--select * from Users where Id=100297

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results