根据帖子ID检索标签

隐式联接：

SELECt title, clean_title, body, published, name, slugFROM posts, posts_tags, tagsWHERe posts.p_id=posts_tags.p_id AND posts_tags.t_id=tags.t_idORDER BY published DESC

显式联接：

SELECt title, clean_title, body, published, name, slugFROM postsLEFT JOIN posts_tags ON posts.p_id=posts_tags.p_idLEFT JOIN tags ON posts_tags.t_id=tags.t_idORDER BY published DESC

一次看到正确的，标准化的数据库架构令人耳目一新。