top accepted answers with help speech

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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 main site
loading Hold tight while we fetch your results