3

Please login or register to vote for this query.

(click on this box to dismiss)

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 system and network administrators

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 < 1
  AND
    p.Body like '%##phrase##%'
  AND
    LEN(p.Body) < 350
  AND
    p.CreationDate > '2015-03-01T00:00:00.001'
  AND
    u.CreationDate > '2014-02-22T00:00:00.000'
  AND
    u.Reputation < 900
  and
    q.Body NOT LIKE '%plugin%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%plugin%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%plug-in%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%plug-in%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%tool%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%tool%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%framework%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%framework%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%API%'
  and
    q.Body NOT LIKE '%API%'
  and
    q.Title NOT LIKE '%library%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%library%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%cms%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%cms%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%open source%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%open source%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%application%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%application%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%software%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%software%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%tutorial%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%tutorial%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%book%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%book%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%module%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%module%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%resource%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%resource%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%engine%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%engine%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%lightweight%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%lightweight%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%opensource%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%opensource%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%technologies%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%technologies%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%simulator%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%simulator%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%compiler%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%compiler%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%editor%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Title NOT LIKE '%editor%' COLLATE SQL_Latin1_General_CP1_CI_AS
  and
    q.Body NOT LIKE '%IDE%'
  and
    q.Title NOT LIKE '%IDE%'
ORDER BY
    BodyLength ASC

fork query

edited mar 8 15 bluet

created feb 9 12 anonymous