SELECT s.*,c.rkzhi FROM dt_sell_5 as s,dt_company as c,dt_member as m WHERE and s.username=c.username and c.username=m.username and status=3 ORDER BY c.rkzhi desc , s.homepro desc, c.vip desc , s.addtime desc LIMIT 0,20