Q&A about the site for members of the workforce navigating the professional setting
SELECT DISTINCT TOP ##num?100## p.Id AS [Post Link], p.OwnerUserId AS [User Link], p.CreationDate, p.LastActivityDate, p.Score, url = 'site://posts/' + CAST(p.Id AS varchar)+'/revisions' FROM Posts p JOIN PostHistory ph ON (ph.PostId=p.Id) cross join string_split(##words:string?e,a##, ',') WHERE text like concat('%', value ,'%') ORDER BY p.CreationDate DESC