Find thank you notes

2

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
    p.Id AS [Post Link],
    LEN(p.Body) AS [Body Length],
    p.Score AS [Post Score],
    u.Reputation AS [User Reputation],
    p.ClosedDate AS [Date Closed]
FROM
    Posts AS p
INNER JOIN
    Users AS u
ON
    u.Id = p.OwnerUserId
WHERE
    p.postTypeId = 2
  AND
    p.Score < 1
  AND
  ((p.Body LIKE '%thanks%') OR (p.Body LIKE '%Thanks%') OR (p.Body LIKE '%Thank you%') OR (p.Body LIKE '%thank you%'))
  AND
    LEN(p.Body) < 500
  AND
    p.CreationDate > '2014-08-03T00:00:00.000'
  
ORDER BY
    [Post Score] ASC

Enter Parameters

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