Discuz查询标签及带此标签的帖子总数

SQL语句：

select t.*,count(ti.tagname) as icount from pre_common_tag as t,pre_common_tagitem as ti where ti.tagname!=' ' and t.tagid=ti.tagid and t.status=0 group by ti.tagname order by icount desc
 

文章来源: blog.csdn.net，作者：fengda2870，版权归原作者所有，如需转载，请联系作者。

原文链接：blog.csdn.net/fengda2870/article/details/8273425