1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT v.PostId AS [Post Link], COUNT(v.PostId), p.score
FROM Posts p
  INNER JOIN Votes v ON p.Id = v.PostId
WHERE
  v.VoteTypeId = 10
  AND p.OwnerUserId = ##UserId##
  AND p.PostTypeId = 2
  AND p.Score < 0
  AND p.DeletionDate IS NULL
GROUP BY v.PostId, p.score
ORDER BY COUNT(v.PostId) DESC

fork query

edited mar 15 General.Grievance

created jun 14 19 TheLethalCarrot