Find my questions and answers with imgur in the body

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

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 
from posts
where owneruserid = ##UserID## AND
Body LIKE '%.gif%' AND
Body NOT LIKE '%http://i.imgur.com/%' AND
Body NOT LIKE '%http://i.stack.imgur.com/%'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached