svip

帝国cms 自定义列表多表查询方法

1. 统计记录:
   
2. select count(*) as total from [!db.pre!]ecms_news  union select count(*) as total from [!db.pre!]ecms_book
   
3. 查询记录:
   
4. select classid,id,titleurl,title,newstime from [!db.pre!]ecms_news union select classid,id,titleurl,title,newstime from [!db.pre!]ecms_book order by newstime desc

复制代码