LQLV

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

declare @start date = dateadd(week, -140, getdate())

SELECT p.Score, p.Id AS [Post Link], u.DisplayName, p.Body
FROM Posts p
JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.PostTypeId = 1 AND LEN(p.Body) >= 1400
and p.CreationDate >= @start
and p.Score <= 1
and p.AnswerCount = 0
and u.Reputation < 210
ORDER BY p.Score ASC

Enter Parameters

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