0

Please login or register to vote for this query.

(click on this box to dismiss)

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

view current version

edited jan 15 17

created jan 15 17 Lefty.G.Balogh