代码:
[e:loop={'select*from(selectid,classid,titleurl,filename,title,newstime,titlepicfromphome_ecms_newswherenewstimeunionselectid,classid,titleurl,filename,title,newstime,titlepicfromphome_ecms_photowherenewstimeunionselectid,classid,titleurl,filename,title,newstime,titlepicfromphome_ecms_flashwherenewstimeunionselectid,classid,titleurl,filename,title,newstime,titlepicfromphome_ecms_articlewherenewstime)aorderbynewstimedesclimit10',10,24,1}][/e:loop]
帝国cms多表查询实现全站最新信息调用(演示代码为默认数据表下全站最新10条图片信息),自己根据需求可以附加条件,实现全站点击,全站头条,全站推荐等等