<!--{block name="bbspost" parameter="sql/SELECT%20t%20.%20%2A%20%2C%20a%20.%20%2A%20%0D%0AFROM%20cdb_threads%20t%0D%0AINNER%20JOIN%20cdb_attachments%20a%20ON%20t.tid%20%3D%20a.tid%0D%0AWHERE%20a.isimage%20%3D1%0D%0AAND%20t.fid%20%3D2%0D%0AGROUP%20BY%20t.tid/limit/0,9/cachetime/900/subjectlen/36/cachename/SocietyTopicPic/tpl/data"}--><!--SocietyTopPic-->
<div class="supeblog_txlist">
<ul>
<!--{loop $_SBLOCK['SocietyTopicPic'] $value}-->
<li><div class="nowrap"><a target="_blank" title="$value[subject]">$value[subject]</a></div></li>
<!--{/loop}-->
</ul>
这是sql语句
SELECT t . * , a . *
FROM cdb_threads t
INNER JOIN cdb_attachments a ON t.tid = a.tid
WHERE a.isimage =1
AND t.fid =2 GROUP BY t.tid