Questions that are eligible for carid coinheringaahing's 50-300 rep bounty

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

SELECT p.Id AS [Post Link],u.DisplayName,p.Score,p.CreationDate,p.ViewCount,p.Tags
FROM Posts p
INNER JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.PostTypeId = 1
AND p.AnswerCount = 0
AND NOT p.Tags LIKE '%tips%'
AND p.Score >= 3
AND p.Score < 15
AND p.CreationDate <= DATEADD(mm,-1,CURRENT_TIMESTAMP)
AND p.ClosedDate IS NULL
ORDER BY p.Score DESC

Enter Parameters

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