Q&A for community managers, administrators, and moderators
Select DISTINCT PostId as [Post Link], Comment, UserId as [User Link], CreationDate, url = 'site://posts/' + CAST(PostId AS varchar)+'/revisions' From PostHistory Where Comment Like '%##keyword##%' and UserId=##id## Order By CreationDate