0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

declare @user_id int = ##UserId##

select
  pl.RelatedPostId as [Post Link],
  count(pl.RelatedPostId) as [Number of Links],
  p.Title, p.Score, p.ViewCount, p.AnswerCount
from PostLinks pl
join Posts p on p.Id = pl.RelatedPostId and p.OwnerUserId = @user_id
group by pl.RelatedPostId, p.ViewCount, p.Score, p.AnswerCount, p.Title
order by [Number of Links] desc

fork query

edited mar 21 16 jon.doe10086

created mar 21 16 anonymous