0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Drupal developers and administrators

-- select Id from Tags where TagName = 'trusted-web-activity'; -- 134123

select Tags.TagName, count(1) ct from PostTags lhpost 
inner join PostTags rhpost on lhpost.PostId = rhpost.PostId
inner join Tags on rhpost.TagId = Tags.Id
where lhpost.TagId = 134123
group by Tags.TagName
order by ct desc;

fork query

edited jan 25

created jan 25 anonymous