统计记录: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
多表查询+多表标题链接的调用[e:loop={ select a.*,b.gsjc from phome_ecms_news a LEFT JOIN phome_ecms_gsj b on a.gsid=b.id where a.clasid in (8) order by a.newstime desc limit 1,5,24,0}]以上A为第一个