~~~ select * from sbh_artnews order by collect/swa limit 6 select * from sbh_artnews order by collect*swa limit 6 select * from sbh_artnews order by collect+swa limit 6 select * from sbh_artnews order by collect-swa limit 6 ~~~ ~~~ select type,count(type) as num from sbh_artswa where unionid=? group by type order by num desc limit 1 ",[ $unionid] ~~~ ~~~ tp5用法 $data=Db::table('sbh_artnews')->where(['isdisplay'=>1])->whereTime('create_time', 'month')->order('`like`/swa','desc')->limit(6)->page(1)->field('`like`/swa b')->select(); ~~~