获取“相关标签"的查询是什么?就像堆栈溢出一样 [英] what is the query to get "related tags" like in stack overflow

问题描述

我有 3 张桌子:

links (id, linkName)  
tags (id, tagName)  
tagsBridge (tagID, linkID)  

我正在尝试支持在 SOF 中显示相关标签.因此，如果您单击标签XYZ"，现在我将显示所有带有标签XYZ"的链接，但我还想显示人们标记了那些也标记为XYZ"的项目的所有其他标签的不同列表

i am trying to support showing related tags like in SOF. so if you click on tags "XYZ", right now i am showing all the links with tag "XYZ" but i also want to show the distinct list of all other tags that people have tagged those items that also have tagged" "XYZ"

最快的查询方式是什么

推荐答案

尝试:

  SELECT t.tagname
    FROM TAGS t
    JOIN TAGS_BRIDGE tb ON tb.tagid = t.id
    JOIN (SELECT li.id
            FROM LINKS li
            JOIN TAGS_BRIDGE tb ON tb.linkid = li.id
            JOIN TAGS t ON t.id = tb.tagid
           WHERE t.tagname = 'XYZ') x ON x.id = tb.linkid
GROUP BY t.tagname

这篇关于获取“相关标签"的查询是什么?就像堆栈溢出一样的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！