Potentially Not An Answer answers to review.

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
  Id as [Post Link],
  Score,
  Body,
  LEN(Body) as Length
FROM Posts
WHERE PostTypeId = 2
AND LEN(Body) < 100
AND Body LIKE '%<a href="%'
--AND (
--  Body LIKE '%blog%' OR
--  Body LIKE '%post%' --OR
----Body LIKE '%forum%' OR
----Body LIKE '%this%help%'
--)
AND NOT Body LIKE '%<blockquote>%'
AND NOT Body LIKE '%<code>%'
ORDER BY Length

Enter Parameters

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