帝国cms自定义列表数据库指令万能调取

统计记录 SQL：

select count(*) as total from [!db.pre!]ecms_news where checked=1 and name_xm="刘明轩" and isgood=1 order by onclick DESC

查询记录 SQL：

select * from [!db.pre!]ecms_news where checked=1 and name_xm="刘明轩" and isgood=1 order by onclick DESC

可以根据关键词keyboard=”关键字”等字段名称加条件进行调取