Most "linked to" posts with the tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

select
  pl.RelatedPostId as [Post Link],
  count(pl.RelatedPostId) as [Number of Links],
  p.Title, p.Score, p.ViewCount, p.Tags, p.AnswerCount
from PostLinks pl
join Posts p on p.Id = pl.RelatedPostId
join PostTags pt on pt.PostId = pl.RelatedPostId
join Tags t on t.Id = pt.TagId
where t.TagName = '##TagName##'
group by pl.RelatedPostId, p.ViewCount, p.Score, p.AnswerCount, p.Title, p.Tags
order by [Number of Links] desc

Enter Parameters

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