SELECT TOP 1000 P.Id AS [Post Link], P.Score, P.CreationD...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 1000
  P.Id AS [Post Link],
  P.Score,
  P.CreationDate,
  P.Body
FROM Posts P
WHERE
  P.CreationDate > '2023-01-01' AND
  --CHARINDEX('<p>}', P.Body COLLATE Latin1_General_BIN) <> 0
  CHARINDEX('{</p>'+CHAR(10)+'<pre><code>', P.Body COLLATE Latin1_General_BIN) <> 0
  --CHARINDEX('<p>&lt;script', P.Body COLLATE Latin1_General_BIN) <> 0
ORDER BY P.Score DESC
;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results