0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for computer enthusiasts and power users

SELECT
  c.Id AS [Comment Link]
FROM
  Comments AS c
INNER JOIN
  Posts AS q
ON
  c.PostId = q.Id
WHERE
  q.PostTypeId = 1
 and
  q.CreationDate < '2013-11-28T00:00:00.000'
 and
  q.AnswerCount = 0
 and
  q.Score = 0
 and
  q.ViewCount < DATEDIFF(DAY, q.CreationDate, GETDATE()) * 1.5
 and
  q.CommentCount = ##numComments?2##
 and
  c.Text LIKE 'what have you tried%' COLLATE SQL_Latin1_General_CP1_CI_AS

fork query

created nov 24 14 anonymous