Order questions by links

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

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
group by pl.RelatedPostId, p.ViewCount, p.Score, p.AnswerCount, p.Title
order by [Number of Links] desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results