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 enthusiasts and power users of the Android operating system
SELECT p.Id AS [Post Link], LEN(p.Body) AS BodyLength FROM Posts AS p JOIN Users AS u ON u.Id = p.OwnerUserId JOIN Posts as q ON p.ParentId = q.Id WHERE q.PostTypeId = 1 AND p.PostTypeId = 2 AND p.Score < 3 AND p.Body like '%##phrase##%' AND LEN(p.Body) < 350 AND p.CreationDate > '2014-08-31T00:00:00.000' AND u.CreationDate > '2013-02-27T00:00:00.000' AND u.Reputation < 5000 and q.Body NOT LIKE '%plugin%' and q.Title NOT LIKE '%plugin%' and q.Body NOT LIKE '%plug-in%' and q.Title NOT LIKE '%plug-in%' and q.Body NOT LIKE '%tool%' and q.Title NOT LIKE '%tool%' and q.Title NOT LIKE '%framework%' and q.Body NOT LIKE '%framework%' and q.Title NOT LIKE '%API%' and q.Body NOT LIKE '%API%' and q.Title NOT LIKE '%library%' and q.Body NOT LIKE '%library%' and q.Title NOT LIKE '%cms%' and q.Body NOT LIKE '%cms%' and q.Title NOT LIKE '%open source%' and q.Body NOT LIKE '%open source%' and q.Body NOT LIKE '%application%' and q.Title NOT LIKE '%application%' and q.Body NOT LIKE '%software%' and q.Title NOT LIKE '%software%' and q.Body NOT LIKE '%tutorial%' and q.Title NOT LIKE '%tutorial%' and q.Body NOT LIKE '%book%' and q.Title NOT LIKE '%book%' and q.Body NOT LIKE '%module%' and q.Title NOT LIKE '%module%' and q.Body NOT LIKE '%resource%' and q.Title NOT LIKE '%resource%' and q.Body NOT LIKE '%engine%' and q.Title NOT LIKE '%engine%' and q.Body NOT LIKE '%lightweight%' and q.Title NOT LIKE '%lightweight%' and q.Body NOT LIKE '%opensource%' and q.Title NOT LIKE '%opensource%' and q.Body NOT LIKE '%technologies%' and q.Title NOT LIKE '%technologies%' and q.Body NOT LIKE '%simulator%' and q.Title NOT LIKE '%simulator%' and q.Body NOT LIKE '%compiler%' and q.Title NOT LIKE '%compiler%' and q.Body NOT LIKE '%editor%' and q.Title NOT LIKE '%editor%' and q.Body NOT LIKE '%IDE%' and q.Title NOT LIKE '%IDE%' ORDER BY BodyLength ASC