◎ 簡(jiǎn)介:帝國(guó)CMS自定義列表查詢(xún)SQL語(yǔ)句,從第N條開(kāi)始查詢(xún)的方法
統(tǒng)計(jì)記錄:
select count(*) as total from [!db.pre!]ecms_news where id>(select id from [!db.pre!]ecms_news order by id desc limit 10,1) and checked=1
查詢(xún)記錄:
select * from phome_ecms_news where checked=1 order by newstime desc
從第10條是開(kāi)始!