帝国cms自定义列表多表查询总计代码
发布时间:2021-10-25 09:28:26 所属栏目:编程 来源:互联网
导读:统计记录: 1 select count(*) as total from [!db.pre!]ecms_news union select count(*) as total from [!db.pre!]ecms_movie 查询记录: 1 select classid,id,titleurl,title,newstime from [!db.pre!]ecms_news union select classid,id,titleurl,title,ne
统计记录:
1
select count(*) as total from [!db.pre!]ecms_news union select count(*) as total from [!db.pre!]ecms_movie
查询记录:
1
select classid,id,titleurl,title,newstime from [!db.pre!]ecms_news union select classid,id,titleurl,title,newstime from [!db.pre!]ecms_movie order by newstime desc
(编辑:核心网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |