Please Note: This query only checks answers made within the last week or so. Some examples of phrases that may likely appear in an answer that should be flagged : - not enough rep (ex: I do not have enough rep to leave a comment, so I posted this as an answer instead!) <br /> - don't have enough - i have a new question - my question is - see this link (ex: The answer to your question can be found in the jQuery docs. See this link.) - see here - this link may help - this is not an answer - thank you - etc
Q&A for active researchers, academics and students of physics
SELECT p.Id AS [Post Link], LEN(p.Body) AS BodyLength, p.CreationDate AS Date FROM Posts AS p INNER JOIN Users AS u ON u.Id = p.OwnerUserId WHERE p.PostTypeId = 2 AND p.Score < 3 AND p.Body like '%##phrase##%' AND LEN(p.Body) < 500 AND p.CommentCount < 10 AND p.CreationDate > '2014-06-22T00:00:00.000' AND u.CreationDate > '2012-01-01T00:00:00.000' AND u.Reputation < 40000 AND u.DownVotes < 800 ORDER BY BodyLength ASC