test

0

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 COUNT(c.Id)
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'

Enter Parameters

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