Over on Ask Ubuntu, we have been using this query to find out old posts with non-imgur images. It was working alright before this weekend, but now it's returning 0 rows. What's going wrong?
The query is specifically looking for images (i.e.
img tags) that have a HTTP
src. As stated in Roadmap to HTTPS: serving and uploading HTTPS-images only, those have been nuked (silently by the Community user, without bumping posts). They were either auto-converted to HTTPS images or plain text links; neither of which will be found by that query.
SEDE is only updated weekly, on Sundays, so the query would have returned the already fixed posts until today when it was updated.