织梦SELECT语句如何使用(2)

{dede:sql sql="SELECT` cdb_p_w_uploads`.`aid`, `cdb_p_w_uploads`.`p_w_upload`,`cdb_threads`.`tid`, `cdb_threads`.`fid`, `cdb_threads`.`subject` FROM `cdb_p_w_uploads` LEFT JOIN `cdb_threads` ON `cdb_threads`.`tid`=`cdb_p_w_uploads`.`tid` WHERE `cdb_p_w_uploads`.`readperm`='0' AND `displayorder`>='0' AND `filetype`='p_w_picpath/pjpeg' GROUP BY tid LIMIT 0,2"}  

<li><A href=https://www.91084.com/"/bbs/viewthread.php?tid=[field:tid /]"><IMG src=https://www.91084.com/"/bbs/p_w_uploads/[field:p_w_upload/]"></A></li>  

<li><A href=https://www.91084.com/"/bbs/viewthread.php?tid=[field:tid /]">[field:subject function="cn_substr('@me',30)" /]</A></li>  

{/dede:sql}

调用说明：调用UCHOME最新日志

{dede:sql sql="Select subject,viewnum,blogid,uid From uchome_blog order by blogid desc limit 0,8"}  

<li><A href=https://www.91084.com/"?uid=[field:uid/]&do=blog&id=[field:blogid/]">[field:subject function="cn_substr('@me',24)" /]</A></li>  

{/dede:sql}

调用说明：会员积分排行

{dede:sql sql="Select mid,userid,uname,scores From dede_member order by scores desc limit 0,10"}  

<dd><span class="name"><a href='[field:global/]/member/?[field:userid/]/'>[field:uname/]</a>  

</span><span class="jifen">积分[field:scores/]</span></dd>