Find all posts where a certain user has edited and included a certain keyword

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 distinct PostHistory.PostId as [Post Link]
from PostHistory
left join Posts on Posts.Id = PostHistory.PostId
where PostHistoryTypeId = 5
and Text like '%' + ##keyword:string## + '%'
and OwnerUserId = ##UserId##
and Posts.CreationDate > ##date##

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results