- SQL语句:
SELECT COUNT(AA.id) AS total FROM ( SELECT id FROM www_moban5_cn_ecms_news UNION ALL SELECT id FROM www_moban5_cn_ecms_xiazai UNION ALL SELECT id FROM www_moban5_cn_ecms_photo UNION ALL SELECT id FROM www_moban5_cn_ecms_download ) AA;
- 在帝国CMS后台使用:
SELECT COUNT(AA.id) AS total FROM ( SELECT id FROM phome_ecms_news UNION ALL SELECT id FROM phome_ecms_xiazai UNION ALL SELECT id FROM phome_ecms_photo UNION ALL SELECT id FROM phome_ecms_download ) AA;
以上是针对帝国CMS的一些常见问题及其解决方案,希望对你有所帮助。如果有更多问题,欢迎继续提问。