【注意】下面的表前缀是 58pic_  要是你自己修过了的，一定自己对照修改。放到你自己想放的位置....

{dede:sql sql="select a.id,a.pubdate,a.litpic,a.title,t.id,t.typedir from  58pic_archives as a left jo 58pic_arctype as t on a.typeid=t.id where a.typeid (69,70,71,72,73,74) and a.flag like '%p%' order by pubdate desc limit 0,4"} 

            <div class="ppfk_cellk L"> 

                  <div class="ppfk_cell"> 

                    <div class="ppfk_cellpic bord"><a href="[field:typedir runphp='yes']@me=str_replace('{cmspath}','','@me');[/field:typedir]/[field:id/].html"><img src='[field:litpic/]' border='0' width='120' height='120' alt='[field:title/]'/></a></div> 

                    <div class=" ppfk_wen"><a href="[field:typedir runphp='yes']@me=str_replace('{cmspath}','','@me');[/field:typedir]/[field:id/].html" title="[field:title/]">[field:title/]</a></div></div></div> 

{/dede:sql}