Posts that consist solely of a spoiler block

0

Please login or register to vote for this query.

(click on this box to dismiss)

Puzzling

Q&A for those who create, solve, and study puzzles

SELECT
  Id As [Post Link],
  CreationDate,
  Score,
  OwnerUserId As [User Link],
  Right(Body, Len(Body)-34) AS [Text]
FROM Posts
WHERE Body LIKE '<blockquote class="spoiler">%'
  AND NOT BODY LIKE '%</blockquote>%<p>%'
ORDER BY Id ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results