Q&A for professional and enthusiast programmers
Select Top 1000 Posts.Id, Posts.Id as [Post Link], PostTypes.Name as [Type], Posts.Score, Posts.CreationDate, Posts.Tags From Posts Join PostTypes on PostTypes.Id = Posts.PostTypeId Where Body Like '%<img%.imageshack.us/img%'