Comments by a user

1

Please login or register to vote for this query.

(click on this box to dismiss)

TeX - LaTeX

Q&A for users of TeX, LaTeX, ConTeXt, and related typesetting systems

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(c.Text) >= ##MinCommentLength:int?0## AND
  LEN(c.Text) <= ##MaxCommentLength:int?500## AND
  (
    c.UserId = ##UserId:int##
  ) 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