Q&A for SharePoint enthusiasts
SELECT CONCAT( 'site://q/' , Posts.Id , '|' , CASE WHEN Posts.PostTypeId = 1 THEN 'Q' ELSE 'A' END , ' - ' , Questions.Title) linkje , Comments.Id , Comments.text FROM Comments INNER JOIN Posts ON Posts.Id = Comments.PostId INNER JOIN Posts Questions ON Questions.Id = COALESCE(Posts.ParentId, Posts.Id) WHERE Comments.text like '%thanks%' AND len(Comments.text) < 20 AND Posts.PostTypeId = 2 ORDER BY Comments.Id DESC