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
  b.Score,
  b.Id AS [Post Link],
  b.CreationDate,
  ISNULL(b.ClosedDate, a.ClosedDate) AS ClosedDate
FROM
  Posts b
  LEFT OUTER JOIN Posts a
    ON b.ParentId = a.Id
WHERE
  b.Body LIKE '%<img%'
  AND b.Body NOT LIKE '%<img src="http://i.stack%'
ORDER BY
  b.CreationDate DESC

Enter Parameters

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