{dede:arclist  addfields='zjid' row='1' channelid='24' }            
[field:zjid runphp="yes"]
global $dsql;
$sql="SELECT dede_archives.*  FROM   dede_archives left JOIN  dede_addon24  ON dede_archives.id=dede_addon24.aid  WHERE  dede_archives.typeid=@me";
$dsql->SetQuery($sql);
$dsql->Execute();
@me="";
while($row = $dsql->GetArray()){
@me.="<li><a href=\"/plus/view.php?aid=".$row['id']."\"><img  src=\"http://***.com".$row['litpic']."\"><br>".$row['title']."</a></li> ";
}
[/field:zjid]
{/dede:arclist}