Highly Voted Questions with an Image


Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

SELECT TOP ##NumberOfPosts:int?50## p.Score, p.Id AS [Post Link],
       p.CreationDate, p.LastActivityDate,
       u.Reputation AS [Author's current reputation]
FROM   Posts p LEFT OUTER JOIN Users u on p.OwnerUserId = u.Id
WHERE  1=1

       -- Edited at least 6 months ago (Archaeologist badge)
       --AND p.LastActivityDate <= DATEADD(DAY, -185, GETDATE())

       --Search for posts by users with relatively low reputation, high reputation users usually know what they're doing
       --AND 50 < u.Reputation AND u.Reputation < 2000

       --If the link is already an image we don't have to do anything
       AND NOT p.Body LIKE '%<img src%'

       --If the OP has enough reputation to post lots of links, he has enough reputation to post images
       AND NOT p.Body LIKE '%<a %<a %'
       AND     p.Body LIKE '%<a href=%imgur.com/%.%>%</a>%'

Enter Parameters

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