dedecms中sql标签调用数据实例分析

{dede:sql sql='Select * from dede_archives where mid=1'}
'/plus/view.php?aid=[field:id/]' target='_blank'>[field:title/]
{/dede:sql}

{dede:sql sql='select d.typename,d.id,count(da.id) as heji from dede_arctype d left join dede_archives da on da.typeid=d.id where d.reid=0 group by d.typename order by heji desc limit 0,8;'}
[[field:heji/]篇] [field:typename/]共投递稿件
{/dede:sql}

{dede:sql sql='select * from rschina_myad where aid =24'}
class="tab1">"#1">[field:adname /]

{/dede:sql}
{dede:sql sql='select * from rschina_myad where aid =25'}
class="tab2">"#2">[field:adname /]

{/dede:sql}
{dede:sql sql='select * from rschina_myad where aid =26'}
class="tab3">"#3">[field:adname /]

{/dede:sql}
{dede:sql sql='select * from rschina_myad where aid =27'}
class="tab4">"#4">[field:adname /]

{/dede:sql}
{dede:sql sql='select * from rschina_myad where aid =28'}
class="tab5">"#5">[field:adname /]

{/dede:sql}