5

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those who study, teach, research and apply economics and econometrics

DECLARE @user INT = ##UserID:int##

select Answer.Id as [Post Link], Answer.Score
FROM Posts as Answer
LEFT JOIN Posts as Question on Answer.ParentId=Question.Id
WHERE Answer.OwnerUserId=@user and Question.Score <= -5
ORDER BY Answer.Score DESC

view current version

edited aug 14 12

created aug 14 12 Brad Mace