LQLV

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

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