0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT c.Id AS [Comment Link]
FROM Comments AS c
INNER JOIN Posts AS a
ON c.PostId = a.Id
INNER JOIN Posts AS q
ON a.ParentId = q.Id
WHERE
  a.PostTypeId = 2
and q.AcceptedAnswerId = a.Id
and c.Text LIKE '%thanks%'
and LEN(c.Text) < 25
and c.Score = 0
and c.CreationDate < '2015-01-01T00:00:00.000'

fork query

edited apr 23 15

created apr 23 15 anonymous