0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT len(Text) as Length, c.Id AS [Comment Link], p.commentcount
  FROM Comments c
  JOIN Posts p ON p.id = c.postid
  WHERE len(Text) >= ##Start:int## AND len(Text) <= ##End:int##
    AND ((lower(Text) LIKE '%thank%' AND len(Text)<=50)
      OR (lower(Text) LIKE '%you[^r ]re%welcome%' AND len(Text)<=50)
      OR (Text LIKE '[-+]1[^0-9]%' AND len(Text)<=100)
      OR (Text LIKE '[\[({][-+]1[^0-9]%' AND len(Text)<=100)
      OR (len(Text)<=600 AND lower(Text) LIKE '%accept%'
          AND (lower(Text) like '%rate%'
            OR lower(Text) like '%answer%'
            OR lower(Text) like '%mark%'
            )
          )
        )
 ORDER BY commentcount DESC

fork query

edited dec 24

created oct 23 James.Risner