2

Please login or register to vote for this query.

(click on this box to dismiss)

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]
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
    u.Reputation <= 11
  AND
    p.CreationDate > '2014-06-01T00:00:00.000'
ORDER BY
    [Post Score] ASC, [Body Length] ASC

fork query

edited aug 15 14

created aug 15 14 AstroCB