select no, type, name, discount, options, area1, area2, address, picture1, comment, point1, point2, point3, pcount, reveal, recommend1, recommend2, recommend3, hits, search_banner, main_banner, com_recommend, if(picture1 = '', 0, 1) as exist, point1 + point2 + point3 as point, (point1 + point2 + point3) / pcount as score from company where no != '' and type = 0 and (area1 = 11) order by exist desc, no desc limit 0, 10