Posts with links to images posted by new users

6

Please login or register to vote for this query.

(click on this box to dismiss)

Users with less than 10 reputation can't post images, so they often post links instead. This query will help you find such posts so that you can edit them and earn reputation fast.

Emacs

Q&A for those using, extending or developing Emacs

SELECT TOP ##number:int?100## Score, Id AS [Post Link], ViewCount, CreationDate, LastActivityDate
FROM   Posts
WHERE  NOT Body LIKE '%<img src%'
       AND PostTypeId = 1
       AND Body LIKE '%reputation%'
       AND Body LIKE '%<a href=%'
       AND Body LIKE '%imgur%'
ORDER BY ViewCount DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results