{dede:sql sql='Select arc.title,arc.litpic 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:title/]
{/dede:sql}