Gets the most commonly associated tags to a particular tag, by number of posts.
Q&A for users and developers of the Cardano cryptocurrency ecosystem
SELECT Tags.TagName AS [Tag Name], COUNT(*) AS [Number of associated posts] FROM PostTags INNER JOIN Tags ON Tags.Id = PostTags.TagId WHERE PostTags.PostId IN ( --Gets all the PostIds that have this tag SELECT DISTINCT PostId FROM PostTags INNER JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName = ##TagName:string## ) AND Tags.TagName <> ##TagName:string##--Remove the tag your looking for from "related" search results. GROUP BY Tags.TagName ORDER BY COUNT(*) DESC