帝国cms使用灵动标签实现多表同时调用最新信息，头条信息等

【排除部分栏目、排除头条和推荐】调用有图片的新闻和文章表的最新数据，最后一个1指必须有标题图片、前两个1表示调用1条头条信息、24是指按sql查询：

灵动标签同时调用多个表的最新内容,多个表用“union”连接：

[e:loop={'select * from ( 
select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_movie where newstime union 
select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_news where newstime union 
select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_photo where newstime union 
select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_flash where newstime union 
select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_article where newstime 
) a order by newstime desc limit 10',10,24,1}] 
<a href="<?=$bqsr['titleurl']?>" target="_blank"><?=$bqr['title']?></a> <br>
[/e:loop]

xgOECMSPLUS
调用新闻和文章表的头条数据，0指不限有无有标题图片、两个4表示调用4条头条信息、24是指按sql查询：

[e:loop={'select * from ( 
select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_news where firsttitle=1 union 
select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_article where firsttitle=1
) a order by newstime desc limit 4',4,24,0}] 
<a href="<?=$bqsr['titleurl']?>" target="_blank"><?=$bqr['title']?></a> <br>
[/e:loop]

调用有图片的新闻和文章表的头条数据，最后一个1指必须有标题图片、前两个1表示调用1条头条信息、24是指按sql查询：

[e:loop={'select * from ( 
select titleurl,newstime,title,titlepic,onclick,smalltext from [!db.pre!]ecms_news where firsttitle=1 and ispic=1 union 
select titleurl,newstime,title,titlepic,onclick,smalltext from [!db.pre!]ecms_article where firsttitle=1 and ispic=1
) a order by newstime desc limit 1',1,24,1}] 
<a href="<?=$bqsr['titleurl']?>" target="_blank"><?=$bqr['title']?></a> <br>
[/e:loop]

【排除部分栏目、排除头条和推荐】调用有图片的新闻和文章表的最新数据，最后一个1指必须有标题图片、前两个1表示调用1条头条信息、24是指按sql查询：

 xgOECMSPLUS

如下示例代码：

[e:loop={'select * from ( 
select titleurl,newstime,title,smalltext from [!db.pre!]ecms_news where newstime and classid not in(24,15,35) and isgood=0 and firsttitle=0 union 
select titleurl,newstime,title,smalltext from [!db.pre!]ecms_article where newstime  and classid not in(24,15,35) and isgood=0 and firsttitle=0 
) a order by newstime desc limit 10',10,24,0}] 
<li><a href='&lt;?=$bqsr['titleurl']?>' target='_blank'><h6>&lt;?=$bqr['title']?></h6><p>&lt;?=$bqr['smalltext']?></p></a></li>
[/e:loop]