Image posts with external links and images by 1-rep users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Graphic Design

Q&A for Graphic Design professionals, students, and enthusiasts

select top 100 Posts.Id as [Post Link], DisplayName, Body from Posts
join Users on OwnerUserId = Users.Id
where Users.Reputation = 1
and Body like '%<img src="%'
-- fugly attempt to catch a href where the href is not http://i.stack.imgur
and (Body like '%<a href="https%' or Body like '%<a href="http://[^i]%'
or Body like '%<a href="http://i[^.]%' or Body like '%<a href="http://i.[^s]%');

Enter Parameters

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