Tag coming with these tags most commonly together

1

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

SELECT TagB.TagName AS [TagName], COUNT(*) AS Count
FROM Tags TagA, PostTags PTA, PostTags PTB, Tags TagB
WHERE
  TagA.TagName = ##TagName:string##
  AND
  TagA.Id = PTA.TagId
  AND
  PTA.PostId = PTB.PostId
  AND
  PTB.TagId != PTA.TagId
  AND
  PTB.TagId = TagB.Id
GROUP BY TagB.TagName
ORDER BY Count DESC, TagB.TagName

Enter Parameters

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