0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

DECLARE @UserId int = ##UserId##

SELECT q.id as [Post Link], q.Score FROM Posts q
INNER JOIN Posts a on a.ParentId = q.id
AND 
    a.OwnerUserId = @UserId
AND
    a.PostTypeId = 2
AND
    q.Score < 0
GROUP BY q.Id, q.Score ORDER BY q.Score

fork query

edited oct 3 22

created sep 20 22 anonymous