Finding bad answers through comments

0

Please login or register to vote for this query.

(click on this box to dismiss)

A lexical search method

Christianity Meta

Q&A about the site for committed Christians, experts in Christianity and those interested in learning more

-- Finding bad answers through comments
-- A lexical search method

SELECT distinct TOP  1000 c.PostId AS [Post Link], c.text AS Body
FROM Comments C, Posts P
Where (
  p.body  LIKE '%reputation%' 
AND
  C.PostID = P.ID AND
  P.ClosedDate IS NULL
)
Order By c.postid desc

Enter Parameters

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