Most "linked to" user posts with tags

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]
from PostLinks pl
join Posts p on p.ParentId = pl.RelatedPostId
join Posts q on q.Id = p.ParentId
where p.OwnerUserId = ##UserId:int##  and q.Tags like '%##Tags##%'
group by pl.RelatedPostId
order by [Number of Links] desc

Enter Parameters

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