統(tǒng)計(jì)記錄:

select count(*) as total from [!db.pre!]ecms_news  union select count(*) as total from [!db.pre!]ecms_movie

查詢記錄:

select classid,id,titleurl,title,newstime from [!db.pre!]ecms_news  union select classid,id,titleurl,title,newstime from [!db.pre!]ecms_movie order  by newstime desc

-----------------------注釋：-------------------------------

以上調(diào)用的是（新聞模型：news、電影模型：movie）兩個(gè)模型的文章，兩個(gè)模型用"Union"連接調(diào)用

若指定欄目用：where classid in(46,47,51)，

若調(diào)用推薦在其后追加：and isgood=1，

若指定調(diào)用條數(shù)在其后追加：limit 10