{dede:sql sql='Select arc.title,arc.litpic,arc.id from mzm_archives arc left join mzm_addonarticle addon on addon.aid = arc.id
where find_in_set(arc.typeid,(select group_concat(id) from mzm_arctype where reid=(select reid from mzm_arctype
where id=(select typeid from mzm_archives where id=~id~))))'}
[field:id runphp='yes']$url=GetOneArchive(@me);@me=$url['arcurl'];[/field:id]
[field:title/]
{/dede:sql}
注意:arc.id必须要写,要根据这个递归出路径。