统计记录:select count(*) as total from [!db.pre!]ecms_news union select count(*) as total from [!db.pre!]ecms_movie查询记录:select clasid,id,titleurl,title,newstime from [!db.pre!]ecm
新增自定义列表页:查询SQL语句:统计记录:select count(*) as total from [!db.pre!]enewsmember查询记录:select u.*,ui.* from [!db.pre!]enewsmember u LEFT JOIN [!db.pre!]enewsmemberadd ui ON u.userid=ui.useri