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

统计记录:
select count(*) as total from [!db.pre!]ecms_newsunion select count(*) as total from [!db.pre!]ecms_book
查询记录:
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