CLEANUP: Find images not hosted on imgur

3

Please login or register to vote for this query.

(click on this box to dismiss)

This query will find most posts that contain at least one image that isn't hosted either on i.imgur.com or i.stack.imgur.com. Note that some images have legitimate reasons for being hosted off-site - maybe they're SVGs (not supported by imgur), or are larger than the imgur upload size limits (4 MB non-gif; 2 MB gif). Also, the [Snippet] column may list an imgur URL; this is because it just lists the URL of the first image it finds. There may still be non-imgur images elsewhere in the post.

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

SELECT
  Id AS [Post Link],
  CreationDate,
  ClosedDate
FROM
  Posts
WHERE
  Body LIKE '%<img%'
  AND Body NOT LIKE '%<img src="http://i.stack%'
ORDER BY
  CreationDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results