CLEANUP: Find images not hosted on imgur

0

Please login or register to vote for this query.

(click on this box to dismiss)

Arqade

Q&A for passionate videogamers on all platforms

--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.

SELECT
  b.Score,
  b.Id AS [Post Link],
  b.CreationDate
FROM
  Posts b
WHERE
  b.Body LIKE '%<img src=%'
ORDER BY
  b.CreationDate DESC

Enter Parameters

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