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

SELECT P.Id AS [Post Link], P.Body
FROM Posts P
WHERE
  P.Id >= 74972583 -- optimized version of CreationDate > '2023-01-01'
  AND CHARINDEX('{</p>'+CHAR(10)+'<pre><code>', P.Body COLLATE Latin1_General_BIN) <> 0

fork query

created jan 27 23 starball