Posts with the most images

0

Please login or register to vote for this query.

(click on this box to dismiss)

Posts containing images, sorted by the number of images.

Stack Overflow

Q&A for professional and enthusiast programmers

select
  Id as [Post Link],
  len(Body) - len(replace(Body, '<img ', '<img')) as [Images],
  Score,
  case PostTypeId when 0 then 'Q' when 1 then 'A' else '?' end as [Type],
  Body
from Posts
where Body like '%<img %'
order by Images desc

Enter Parameters

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