Web_PHP_DedeCMS_{dede:sql}标签用法；

{dede:sql sql='select a.title,a.litpic,z.expert,d.level,d.titles,d.resume from dede_archives as a,dede_addonzjtb as z,dede_addondocter as d where a.id = z.aid and z.expert = d.name AND a.litpic is not null GROUP BY a.title LIMIT 2'}
				<div class="new_nl1" style="color:#333;">
					<div class="new_nl1_l left">第
						<br />
						<span>[field:global.autoindex/]</span>
						<br />期
					</div>
					<div class="new_nl1_c left">
						<a href="/" target="_blank">
							<img src="[field:litpic/]" />
						</a>
					</div>
					<div class="new_nl1_r left">
						<h2><a href="/" target="_blank">[field:title/]</a></h2>
						<h3>解答专家：<strong>[field:expert/] [field:level/]</strong></h3>
						<p><strong>[专家简介]</strong>：[field:titles/]</p>
						<p>[field:resume function='cn_substr(@me,175)'/]...<a href="/" class="red" target="_blank">[查看详细]</a>
						</p>
						<h5><a href="#" target="_blank">我要咨询糖尿病专家</a></h5>
					</div>
				</div>
			{/dede:sql}