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 

LIMIT 0 , 10"} 

<a href='[field:url/]'>[field:title function="cn_substr(@me,50)"/]</a> 

<a href='[field:global name='cfg_cmspath'/]/member/?[field:uid/]/'>[field:uname/]</a> 

{/dede:sql}

 

推荐企业 

{dede:sql sql="SELECT m.ID,m.type,m.userid,m.matt,c.id,c.comname 

FROM dede_member m 

left join dede_member_cominfo c on m.ID = c.id 

where m.type = 1 and m.matt = 1 

LIMIT 0 , 10"} 

<a href='[field:global name='cfg_cmspath'/]/member/?[field:userid/]/'>[field:comname/]</a> 

{/dede:sql}

最新企业调用 

{dede:sql sql="SELECT m.ID, m.type, m.userid,c.id, c.comname 

FROM dede_member m 

LEFT JOIN dede_member_cominfo c ON m.ID = c.id 

WHERE m.type =1 

ORDER BY `m`.`ID` DESC 

LIMIT 0 , 10 "} 

<a href='[field:global name='cfg_cmspath'/]/member/?[field:userid/]/'>[field:comname/]</a> 

{/dede:sql}

推荐会员（带用户头像）调用方法 

推荐企业

{dede:sql sql="SELECT m.ID,m.type,m.userid,m.matt,m.spacep_w_picpath,c.id,c.comname 

FROM dede_member m left join dede_member_cominfo c on m.ID = c.id 

where m.type = 1 and m.matt = 1 

LIMIT 0 , 5"} 

头像：<img src="[field:spacep_w_picpath runphp='yes'] 

if(!@me)@me = 'http://bbs.dedecms.com/p_w_picpath/post/smile/default/14.gif'; 

[/field:spacep_w_picpath]" /> 

用户名：<a href='[field:global name='cfg_cmspath'/]/member/?[field:userid/]/'>[field:comname/]</a> 

{/dede:sql}

推荐会员

{dede:sql sql="SELECT ID,type,userid,uname,matt,spacep_w_picpath 

FROM dede_member 

where matt = 1 and type=0 

LIMIT 0 , 10"} 

头像：<img src="[field:spacep_w_picpath runphp='yes'] 

if(!@me)@me = 'http://bbs.dedecms.com/p_w_picpath/post/smile/default/14.gif'; 

[/field:spacep_w_picpath]" /> 

用户名：<a href='[field:global name='cfg_cmspath'/]/member/?[field:userid/]/'>[field:uname/]</a> 

{/dede:sql}

为用户头像图片 [field:spacep_w_picpath runphp='yes'] 

if(!@me)@me = 'http://bbs.dedecms.com/p_w_picpath/post/smile/default/14.gif'; 

[/field:spacep_w_picpath]

5个推荐企业 包含企业简介

{dede:sql sql="SELECT m.userid,m.comname,c.cominfo 

FROM dede_member m left join dede_member_cominfo c on m.ID = c.id 

where m.type = 1 and m.matt = 1 

LIMIT 0 , 5"} 

 

企业名称：<a href='[field:global name='cfg_cmspath'/]/member/?[field:userid/]/'>[field:comname/]</a> 

企业简介：[field:cominfo function="cn_substr(ClearHtml(@me),100)"/] 

{/dede:sql}

最新招聘信息

{dede:sql sql="SELECT * FROM dede_jobs ORDER BY pubdate DESC LIMIT 0 , 10"} 

<a href="/member/index.php?id=3">[field:name/]</a>招聘<a href="/member/index.php?id=[field:memberID/]&type=job&jobid=[field:id/]">[field:job/]</a><br/> 

{/dede:sql}