1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

SELECT TOP 100 CONCAT(
           'site://q/'
         , Posts.Id
         , '|'
         , CASE WHEN Posts.PostTypeId = 1 THEN 'Q' ELSE 'A' END
         , ' - '
         , Questions.Title) linkje
         , Posts.AcceptedAnswerId
         , Questions.AcceptedAnswerId
         , Comments.PostId
         , 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

fork query

created aug 8 22 anonymous