select pro.id, pro.cname,pro.cplx,pro.zstype,pro.price,pro.dgnum,pro.kcnum,usr.utype,aut.company from 1039ok_sb_info pro LEFT JOIN 1039ok_user usr ON pro.userid=usr.id LEFT JOIN 1039ok_user_othermsg aut ON pro.userid=aut.userid WHERE pro.`status`=1 and pro.fprovince='710000'order by pro.id asc