My posts created after Aug 17, 2010 containing Stack Exchange imgur URL

0

Please login or register to vote for this query.

(click on this box to dismiss)

For all posts made on or after August 17 2010, any image urls in the form of i.imgur.com were changed to i.stack.imgur.com network-wide. This is resulted in many broken images if the image was not uploaded using the Stack Exchange uploader. This query will list all posts so that the broken links can be fixed Refer http://meta.stackoverflow.com/questions/95732/images-manually-uploaded-to-imgur-are-not-displaying/95734#95734, http://meta.superuser.com/questions/2953/some-images-from-i-stack-imgur-com-images-only-show-an-error-message for more details

Stack Overflow

Q&A for professional and enthusiast programmers

-- My posts created after Aug 17, 2010 containing Stack Exchange imgur URL
-- For all posts made on or after August 17 2010, any image urls in the form of i.imgur.com were changed to i.stack.imgur.com network-wide. This is resulted in many broken images if the image was not uploaded using the Stack Exchange uploader. This query will list all posts so that the broken links can be fixed
-- 
-- Refer http://meta.stackoverflow.com/questions/95732/images-manually-uploaded-to-imgur-are-not-displaying/95734#95734, http://meta.superuser.com/questions/2953/some-images-from-i-stack-imgur-com-images-only-show-an-error-message for more details

select id [Post Link], Body, CreationDate 
from posts
where owneruserid = ##UserID## 
and creationdate > '2010-08-17 00:00:00'
and body like '%http://i.stack%'

Enter Parameters

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