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.Id AS [Post Link],
  b.CreationDate,
  b.ClosedDate,
  a.ClosedDate AS ParentClosedDate
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