Q&A for peer programmer code reviews
SELECT TOP 100 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 '%accept%' AND Comments.text like '%mark%' AND Comments.UserId = Posts.OwnerUserId AND Posts.PostTypeId = 2 ORDER BY Comments.Id DESC