1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Muslims, experts in Islam, and those interested in learning more about Islam

Select P.Id as [Post Link], V.BountyAmount, (SELECT P2.Tags from Posts P2 WHERE P2.Id = P.ParentId) AS [Tags], (SELECT P2.Score from Posts P2 WHERE P2.Id = P.ParentId) AS SCORES
FROM Posts P, Votes V
WHERE 
P.Id = V.PostId
AND
V.BountyAmount > 0
AND
V.VoteTypeId = 9
AND (SELECT P2.Score from Posts P2 WHERE P2.Id = P.ParentId) > V.BountyAmount * 10
ORDER BY 
SCORES DESC, P.CreationDate DESC

view current version

edited mar 5 14

created mar 5 14 Paul Sweatte