top accepted answers with help speech

0

Please login or register to vote for this query.

(click on this box to dismiss)

Signal Processing

Q&A for practitioners of the art and science of signal, image and video processing

SELECT Top 10 
   a.ParentId as [Post Link]
   ,a.body as [Answer]
   ,a.score
FROM
    Posts q
  INNER JOIN
    Posts a ON q.AcceptedAnswerId = a.Id  --this join only finds accepted answers
    and q.CreationDate >= DATEADD(m, -2, GETDATE())
where a.posttypeid = 2 --only answers
and a.CreationDate >= DATEADD(m, -2, GETDATE()) --date range for performance
and a.score > 25   --upvotes
--terms list
and ((a.body like '%truth%') OR (a.body like '%peace%')
OR (a.body like '%wisdom%') OR (a.body like '%found%')
OR (a.body like '%respect%') OR (a.body like '%kindness%'))

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results