孤独的狐狸

推荐企业
{dede:sql sql="SELECT m.mtype,c.company,m.userid FROM dede_member as m left join dede_member_company c on m.mid = c.mid where m.matt='1' and m.mtype ='企业'"}
<li><span><a href='/member/index.php?uid=[field:userid/]' target="_blank">[field:company/]</a></span>　用户:[field:userid/]</li>
{/dede:sql}

最新企业
{dede:sql sql="SELECT m.mtype,c.company,m.userid FROM dede_member as m left join dede_member_company c on m.mid = c.mid where m.mtype ='企业'"}
<li><span><a href='/member/index.php?uid=[field:userid/]' target="_blank">[field:company/]</a></span>　用户:[field:userid/]</li>
{/dede:sql}