Server shutdown in progress<br>select concat(min(a.price*1),'-',max(a.price*1)) as price,b.* FROM ***_ecms_chexing a LEFT JOIN ***_ecms_chexi b ON a.chexi = b.id   where a.id<>'' and b.id<>'' and a.price <> '' AND b.brand = 32 AND a.type = 1 AND a.level = 1 AND a.guobie = 8 AND b.changshang = 43 AND a.gongxinxuhang <= 100 AND a.price >= 20 AND a.price <= 25  GROUP BY b.id order by a.id desc limit 0,12