调用说明：调用Discuz论坛附件带图片的贴子

{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="/bbs/viewthread.php?tid=[field:tid /]"><IMG src="/bbs/p_w_uploads/[field:p_w_upload/]"></A></li>

<li><A href="/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="/space.php?uid=[field:uid/]&do=blog&id=[field:blogid/]" > [field:subject function="cn_substr('@me',24)" /]</A></li>

{/dede:sql}

调用说明：会员积分排行

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