Comments that mention "mark" and "accept".

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフロー

プログラマーとプログラミングに熱心な人々のための質問と回答

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results