Questions of the Week

0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions within the last week with more than x score.

Motor Vehicle Maintenance and Repair Meta

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

-- Questions of the Week
-- Questions within the last week with more than x score.

DECLARE
  @MinimumScore int

SET @MinimumScore = ##MinimumScore##

SELECT TOP 20 Score, CreationDate, Id AS [Post Link]
FROM Posts
WHERE Score >= @MinimumScore
AND CreationDate >= DATEADD(d, -15, GETDATE())
AND PostTypeId = 1
ORDER BY Score DESC, CreationDate DESC;

Enter Parameters

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