SELECT a.* FROM violet_building a 
                left join violet_sales b 
                on b.buildid=a.buildid 
                left join violet_openinfo c 
                on c.buildid=a.buildid 
                WHERE a.del=0 and a.areaid=88 and a.buildname like '%' group by a.buildid order by a.orderby DESC limit 0,10