{dede:sql sql='Select b.*,a.title,a.id from dede_archives as a left join dede_addon14 as b on b.aid=a.id where a.mid=1 limit 0,1'}
<a href='/plus/view.php?aid=[field:id/]' target='_blank'>[field:title/]</a>
{/dede:sql}
{dede:sql sql='Select b.*,a.title,a.id from dede_archives as a left join dede_addon14 as b on b.aid=a.id where a.mid=1 limit 0,1'}
<a href='/plus/view.php?aid=[field:id/]' target='_blank'>[field:title/]</a>
{/dede:sql}
