1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professors, theologians, and those interested in exegetical analysis of biblical texts

-- Recommendations for learning resources [is off-topic for stackoverflow.com](https://stackoverflow.com/help/on-topic)

-- How to respond to "good answers" to such questions:
--  (but brace yourself for possibly unhappy responses)
--  Note: As of 2014-09-12, _questions_ asking for recommendations for learning resources [are off-topic for stackoverflow.com Q&A](https://stackoverflow.com/help/on-topic). If you would like to _ensure_ your answer lives on for posterity, consider whether any of it could fit [in a tag wiki](https://meta.stackexchange.com/a/214338/997587).

SELECT TOP 1000
  Q.Id as [Post Link]
  ,Q.Score
  ,Q.Body
  ,Q.CreationDate
FROM Posts Q
WHERE
  Q.PostTypeId = 1 -- Question
  AND Q.Score < 10
  AND Q.DeletionDate IS NULL
  AND Q.ClosedDate IS NULL
  AND Q.Body COLLATE Latin1_General_BIN LIKE '% recommend%'
  AND (
  Q.Body COLLATE Latin1_General_BIN LIKE '% book%' OR
  Q.Body COLLATE Latin1_General_BIN LIKE '% tutorial%'
  )
  AND Q.Body COLLATE Latin1_General_BIN LIKE '%?%'
  AND LEN(Q.Body) < 600
--ORDER BY Q.CreationDate
;

fork query

created oct 23 22 starball