Comments Search with Score, Length, Age Filters

1

Please login or register to vote for this query.

(click on this box to dismiss)

Constructed Languages

Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally

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

Enter Parameters

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