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.

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT TOP ##NumberOfPosts:int?100## Posts.Score, Posts.Id AS [Post Link], Posts.CreationDate, Posts.LastActivityDate, Users.Reputation AS [Author's current reputation]
FROM   Posts INNER JOIN Users on Posts.OwnerUserId = Users.Id
WHERE  Users.Reputation < 2000
       AND NOT Posts.Body LIKE '%<img src%'
       AND (
           Posts.Body LIKE '%<a href=%imgur%.png%>%</a>%'
           OR Posts.Body LIKE '%<a href=%imgur%.gif%>%</a>%'
           OR Posts.Body LIKE '%<a href=%imgur%.jpg%>%</a>%'
           OR Posts.Body LIKE '%<a href=%imgur%.jpe%>%</a>%'
           OR Posts.Body LIKE '%<a href=%imgur%.bmp%>%</a>%'
       )
ORDER BY Score DESC

Enter Parameters

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