select A.Id, A.PostTypeId, A.Title, A.Body, A.Tags, A.Clo...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select A.Id, 
A.PostTypeId,
A.Title, A.Body, A.Tags, A.ClosedDate, 
A.AnswerCount, A.CommentCount,
A.FavoriteCount, A.ViewCount, A.Score
from Posts as A
inner join PostHistory as B on A.Id = B.PostId
where (A.PostTypeId = 1) and (B.PostHistoryTypeId = 10)
order by A.CreationDate

Enter Parameters

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