Q&A for programmers
-- Find my questions and answers with imgur in the body
-- Due to a migration to i.stack.imgur.com, some images are broken.
-- This query lists all posts so another script can try all images (HEAD) and report invalid images
select id [Post Link], Body, CreationDate
where owneruserid = ##UserID## AND
Body LIKE '%.gif%' AND
Body NOT LIKE '%http://i.imgur.com/%' AND
Body NOT LIKE '%http://i.stack.imgur.com/%'