DEDE 会员调用方法 调用12个企业会员 按 注册时间排序 {dede:sql sql=select * from dede_member where mtype=企业 order by mid limit 0,12} a href=../member/index.php?uid=[field:userid/] target=_blank[field:uname/]/a {/dede:sql} 调用...
调用会员发布的最新10条文档 {dede:sql sql=SELECT f.title,f.url,m.uname,m.id as uid FROM dede_archives a left join dede_full_search f on a.ID = f.aid left join dede_member m on a.memberID = m.ID WHERE memberID 0 ORDER BY `sortrank` DESC LIM...