Q&A for scientists using computers to solve scientific problems
;with counts_cte AS (SELECT RelatedPostId AS id, COUNT(PostId) AS count FROM PostLinks WHERE (LinkTypeId IN (##linktypes?1,3##)) GROUP BY RelatedPostId ---LinkTypeId type of link ---1 = Linked (PostId contains a link to RelatedPostId) ---3 = Duplicate (PostId is a duplicate of RelatedPostId) ) SELECT TOP(##num?500##) p.Id AS [Post Link], c.count, linked = 'site://questions/linked/' + CAST(p.Id AS varchar), p.Title, p.Score, p.ViewCount, p.AnswerCount, p.Tags, p.OwnerUserId AS [User Link] FROM counts_cte c INNER JOIN Posts p ON p.id=c.id WHERE p.OwnerUserId=##userid## ORDER BY c.count DESC