织梦sql调用多个指定栏目,指定文章
<!--sql调用多个指定栏目,文章-->
{dede:sql sql="select a.id,a.pubdate,a.litpic,a.title,t.id,t.typedir from #@__archives as a left join #@__arctype as t on a.typeid=t.id where a.typeid in(69,70,71,72,73,74) and a.flag like '%p%' order by pubdate desc limit 0,4"}
<div 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}