0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Parent:
-- http://data.stackexchange.com/stackoverflow/query/238183/comments-like-what-have-you-tried-where-an-accepted-answer-is-present#

SELECT
    c.Id AS [Comment Link],
    c.Score,
    c.CreationDate,
    LEN(Text)
FROM
    Comments c
      INNER JOIN Posts p
      ON c.PostId = p.Id
WHERE Text LIKE 'What have you tried%'
AND p.AcceptedAnswerId IS NOT NULL
AND LEN(Text) < 33
AND p.CommentCount < ##CommentThread:int?4##
AND c.CreationDate >= '2014-01-01T00:00:00.000'
AND c.CreationDate <= '2014-12-31T23:59:59.999'
ORDER BY
  LEN(Text), c.Score DESC, c.CreationDate

fork query

created dec 21 14 Unihedron