LQLV

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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) >= 2100
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 main site
loading Hold tight while we fetch your results