{dede:sql sql="SELECT * FROM dede_archives a LEFT JOIN dede_addonimages as b ON a.id = b.aid WHERE b.aid IN(~wenzhang~)"}
<h3>[field:title/]</h3>[field:body/]<img src="[field:litpic/]">[field:wenzhang/]
{/dede:sql}
{dede:sql sql="SELECT * FROM dede_archives a LEFT JOIN dede_addonarticle as b ON a.id = b.aid WHERE b.aid IN(~wenzhang~)"}
<h3>[field:title/]</h3>[field:body/]
{/dede:sql}
<!-- {dede:sql sql="SELECT * FROM dede_archives WHERE arcrank>-1 AND id in(~wenzhang~) ORDER BY FIELD(id,~wenzhang~)"}
<h3>[field:title/]</h3>
<img src="[field:litpic/]">
{/dede:sql} -->