select grade,a.company,a.main_pro,a.userid,a.user,a.tel,a.area,a.logo,a.addr,b.sellerpoints,b.name from esaga_shop a left join esaga_member b on a.userid=b.userid WHERE a.shop_statu=1 order by rank,userid descUnknown column 'a.area' in 'field list'