CLEANUP: Find images not hosted on imgur

0

Please login or register to vote for this query.

(click on this box to dismiss)

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%' 
    --contains images
  AND b.Body NOT LIKE '%<img src="http://i.stack.imgur%' 
  AND b.Body NOT LIKE '%<img src="http://i.imgur%'
    --none of which are hosted on stack.imgur or regular imgur
ORDER BY
  b.CreationDate DESC

Enter Parameters

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