Comments replying to a user

1

Please login or register to vote for this query.

(click on this box to dismiss)

Sports

Q&A for participants in team and individual sport activities

SELECT TOP ##Limit:int?50000##
  c.Text AS [Text],
  'site://posts/comments/' + CONVERT(nvarchar(20),c.Id) AS [Comment Permalink]
FROM Comments c
WHERE
  LEN(Text) >= ##MinCommentLength:int?0## AND
  LEN(Text) <= ##MaxCommentLength:int?500## + LEN('@##UsernameWithoutSpaces## ') AND
  (
    LOWER(Text) LIKE LOWER('@##UsernameWithoutSpaces## %')
  ) AND
  c.CreationDate < DATEADD(dd, -##MinCommentAgeDays:int?0##, GETDATE())
ORDER BY c.CreationDate ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results