Q&A about the site for people studying math at any level and professionals in related fields
Select DISTINCT TOP(##num?1000##) PostId as [Post Link], Comment, UserId as [User Link], CreationDate, url = 'site://posts/' + CAST(PostId AS varchar)+'/revisions' From PostHistory Where Comment Like '%##keyword##%' Order By CreationDate DESC