<!--{eval $mtags = DB::fetch_all("SELECT a.tagid, a.tagname, count(b.tagid) as tag_count FROM ".DB::table("common_tag")." a LEFT JOIN ".DB::table("common_tagitem")." b on b.tagid=a.tagid WHERE a.`status` = 0 group by b.tagid ORDER BY a.`tagid` DESC LIMIT 0,100");}--> <div class="fmtags"> <!--{loop $mtags $mtag}--> <!--{if $mtag[tag_count]>0}--> <a href="misc.php?mod=tag&id=$mtag[tagid]" target="_blank" class="xi2">$mtag[tagname]{$mtag[tag_count]}</a> <!--{/if}--> <!--{/loop}--> </div> 复制代码 如果要按标签相关帖子数来排序，ORDER BY `tag_count`。
