1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and amateur woodworkers

SELECT TOP ##Limit:int?100##
  Score,
  LOWER(Text) AS [Text],
  Id AS [Id],
  'site://posts/comments/' + CONVERT(nvarchar(20),Id) AS [Comment Permalink]
FROM Comments c
WHERE
  Score >= ##MinCommentScore:int?0## AND
  Score <= ##MaxCommentScore:int?3## AND
  LEN(Text) >= ##MinCommentLength:int?15## AND
  LEN(Text) <= ##MaxCommentLength:int?15## AND
  Id >= ##MinCommentId:int?0## AND
  CreationDate < DATEADD(dd, -##MinCommentAgeDays:int?60##, GETDATE())
ORDER BY Id ASC

view current version

edited dec 9 19

created dec 7 19 Samuel Liew