Finding bad answers


Please login or register to vote for this query.

(click on this box to dismiss)

A lexical search method


Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

-- Finding bad answers
-- A lexical search method

SELECT TOP 1000 P.Score, p.Id AS [Post Link], YEAR(p.CreationDate) AS Year, Month(p.CreationDate) AS Month, p.Body AS Body, U.DisplayName AS UserName
FROM Posts P, Users U
Where (
  P.PostTypeID = 2 AND 
  P.Score = 0 AND 
  P.Body LIKE '%have a solution%' AND
  P.OwnerUserID = U.ID AND
  U.Reputation < 100 AND
  P.ClosedDate IS NULL)

Order By Year, Month

Enter Parameters

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