DEDE首页调用DZ论坛图片的方法

1. {dede:sql sql="SELECT`cdb_attachments`.`aid`, `cdb_attachments`.`attachment`,`cdb_threads`.`tid`, `cdb_threads`.`fid`, `cdb_threads`.`subject` FROM `cdb_attachments` LEFT JOIN `cdb_threads` ON `cdb_threads`.`tid`=`cdb_attachments`.`tid` WHERE `cdb_attachments`.`readperm`='0' AND `displayorder`>='0' AND `filetype`='image/pjpeg' GROUP BY tid LIMIT 0,1 "}
2. <a href="/bbs/viewthread.php?tid=[field:tid /]">
3. <img src="/bbs/attachments/[field:attachment/]"  ALT="[field:subject/]" width="100" height="80" border="0" />
4. </A>
5. {/dede:sql}