Comments that mention "thanks"

0

Please login or register to vote for this query.

(click on this box to dismiss)

SharePoint

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) < 80
  AND Posts.PostTypeId = 2
ORDER BY Comments.Id DESC

Enter Parameters

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