dedecms5.7织梦常用的几个SQL标记

{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"}