RECENTs =-=-=-=-

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Find recent posts
-- With Lowest scores

select top 100 p.Id AS [Post Link], 
  p.score, u.reputation,
  p.CreationDate, DATEDIFF(DAY, GETDATE(),  p.CreationDate),
  p.body
from posts as p
inner join [users] as u on u.id = p.owneruserid
where posttypeid = 2
  and DATEDIFF(DAY, p.CreationDate, GETDATE()) < 5
--and DATEDIFF(DAY, GETDATE(),  p.CreationDate) > -2
--and (body like '%how can%' or
--     body like '%same problem%' or
--     body like '%thank%' or
--     body like '%please%' or
--     body like '%plz%' or
--     body like '%pls%')
and u.reputation < 100
and p.score < 1
order by LEN(p.body) ASC 
--order by p.score ASC

Enter Parameters

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