<h2>代表作品</h2>
<ul>
	{dede:sql sql="SELECT arc.,addf. FROM `58pic_archives` arc LEFT JOIN `58pic_addonimages` addf ON arc.id=addf.aid WHERE arc.arcrank>-1 AND addf.designer=~title~ LIMIT 10"}
	<li>
		<a href="[field:id runphp=yes]$id=@me;$url=GetOneArchive($id);@me=$url['arcurl'];[/field:id]"><img src="[field:litpic/]">[field:title/]</a>
		<p>风格[field:fengge/]</p>
	</li>
	{/dede:sql}
</ul>复制

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9

<h2>本案例设计师简介</h2>
<div class="designer">
	{dede:sql sql="SELECT arc.,addf. FROM `58pic_archives` arc LEFT JOIN `58pic_addonarticle` addf ON arc.id=addf.aid WHERE arc.arcrank>-1 AND arc.title=~designer~ LIMIT 1"}
	<img src="[field:litpic/]">
	<p>姓名[field:title/]</p>
	<p>职位[field:zhiwei/]</p>
	<p>
		<a href="[field:id runphp=yes]$id=@me;$url=GetOneArchive($id);@me=$url['arcurl'];[/field:id]">更多详情</a>
		<a href="[field:id runphp=yes]$id=@me;$url=GetOneArchive($id);@me=$url['arcurl'];[/field:id]">预约设计</a>
	</p>
	{/dede:sql}
</div>