SELECT p.Score, p.Id AS [Post Link], p.ViewCount, p.Tags,...

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

SELECT 
p.Score, p.Id AS [Post Link], p.ViewCount, p.Tags, DATEDIFF(day, p.CreationDate, GETUTCDATE()) as DaysOld
FROM Posts p
WHERE 
p.Id = 13333707 AND
p.PostTypeId = 1 AND 
p.ViewCount < DATEDIFF(day, p.CreationDate, GETUTCDATE()) * 1.5 AND 
p.Score < 1 AND 
--ISNULL(p.AnswerCount,0) = 0 AND
--ISNULL(p.CommentCount,0) <= 1 AND 
--DATEDIFF(day, p.CreationDate, GETUTCDATE()) > 365
--ORDER BY p.Score, p.ViewCount
1 = 1

Enter Parameters

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