王国cms动感标识启用多表多实体模型启用文章内

[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] 王国CMS多表启用全新信息内容,该演试编码为默认设置数据信息表下整站全新10条照片信息内容,自身依据要求能够额外标准,完成整站点一下,整站今日头条,整站强烈推荐这些.
注解:之上好几个实体模型用 Union 联接启用
若只启用照片:得加ispic=1标准
[e:loop={'select * from (
select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_news where newstime and ispic=1 union
select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_photo where newstime and ispic=1 union
select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_flash where newstime and ispic=1 union
select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_article where newstime and ispic=1) a order by newstime desc limit 10',10,24,1}]
 a href=" ?=$bqsr['titleurl']? " target="_blank" img src=" ?=$bqr['titlepic']? "/ ?=$bqr['title']? /a br 
[/e:loop]