Q&A for Graphic Design professionals, students, and enthusiasts
select top 100
Post.Id as [Post Link],
PostTypes.Name as [Type],
when Author.Id is null then Post.OwnerDisplayName
else 'site://users/' + cast(Author.Id as varchar) + '|' + Author.DisplayName
end as [Author],
coalesce(Post.ViewCount, Parent.ViewCount) as [Views],
coalesce(Post.Tags, Parent.Tags) as [Tags]
from Posts as Post
join PostTypes on Post.PostTypeId = PostTypes.Id
left join Posts as Parent on Post.ParentId = Parent.Id
left join Users as Author on Post.OwnerUserId = Author.Id
where Post.Body like '%<img src="http://%'
and replace(Post.Body, '<img src="http://i.stack.imgur.com', 'X') like '%<img src="http://%'