{dede:sql sql="SELECT a.title,a.litpic,a.id,b.xilie FROM dede_archives as a,dede_addonimages18 as b where a.id=b.aid and b.xilie like '珍珠' order by id desc limit 6 " }
								<div class="block">
									<div class="pic">
										<a href='[field:id runphp='yes']$url=GetOneArchive(@me);@me=$url['arcurl'];[/field:id]' target="_blank">[field:array runphp='yes']@me = (empty(@me['litpic']) ? "" : "<img src='{@me['litpic']}' alt='{@me['title']}' />"); [/field:array]</a>
									</div>
									<div class="line"></div>
									<div class="tet">
										<p><span>名称：</span>[field:title/]</p>
										<p><span>归类：</span>[field:xilie/]系列</p>
									</div>

								</div>
								{/dede:sql}

addonimages18是自定义的模型表单


推荐内容调用

{dede:sql sql="SELECT a.title,a.litpic,a.flag,a.id,b.lx,b.fd,b.inlogo FROM dede_archives as a,dede_addonimages as b where a.id=b.aid and b.lx like '社交广告' order by id desc limit 6 " }
								
										<a style="display:[field:array runphp='yes']if(@me['flag']=='c,p') @me='block';else @me="none";[/field:array]" href='[field:id runphp='yes']$url=GetOneArchive(@me);@me=$url['arcurl'];[/field:id]' target="_blank">[field:array runphp='yes']@me = (empty(@me['litpic']) ? "" : "<li><img src='{@me['inlogo']}' alt='{@me['title']}' /><p>{@me['title']}</p>"); [/field:array]
							<p style="margin-top: -20px;">账户返点：<span>[field:fd/]%</span></p>
						</li>
					</a>
{/dede:sql}