Q&A about the site for people who like playing board games, designing board games or modifying the rules of existing board games
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 -- Only needed on Stack Overflow --AND p.CreationDate >= DATEADD(DAY, -28, GETDATE()) -- 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>%' ORDER BY p.Score DESC