Candidate obsolete comments mentioning accept rate

0

Please login or register to vote for this query.

(click on this box to dismiss)

Picks up variations like 'acceptance' rate, and references to meta post on accepting answers.

Stack Overflow

Q&A for professional and enthusiast programmers

-- Candidate obsolete comments mentioning accept rate
-- Picks up variations like 'acceptance' rate and references to meta post on accepting answers.
-- Modified to restrict to questions that have accepted answers.

select 
  c.PostId as [Post Link],
  c.CreationDate
from Comments c
join Posts a
on   a.Id = c.PostId
and  a.PostTypeId = 2 -- Answer
join Posts q
on   q.Id = a.ParentId
and  q.PostTypeId = 1 -- Question
where (
      c.Text LIKE '%accept% rate%'
      or c.Text LIKE '%/5234/%'
      )
and  q.AcceptedAnswerId is not null
and  q.CreationDate > '1 Jan 2013'
and  a.CreationDate > '1 Jan 2013'
and  c.CreationDate > '1 Jan 2013'
order by
      c.CreationDate

Enter Parameters

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