统计记录:selectcount(*)astotalfrom[!db.pre!]ecms_movie查询记录:select*from[!db.pre!]ecms_movieorderbyiddesc注释：[!db.pre!]ecms_movie为数据表类型（mo…

栏目排序：orderby`classid`desc
按栏目ID降序
orderby`classid`asc
按栏目ID升序
orderbymyorderdesc
按栏目自定义排序orderbymyorderasc按栏目自定义降序
…

SQL:selecta.id,a.classid,a.title,a.titlepic,a.username,a.userid,a.applynum,a.onclick,a.titleurl,b.id,b.classid,count(b.id)fromphome_ecms_newsasaleftjoin…