Server shutdown in progress<br>SELECT count(*) as total FROM  (SELECT count(a.id) as total 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 = 2 AND a.type = 5 AND a.level = 8 AND a.guobie = 7 AND a.qudong = 1 AND a.gongxinxuhang >= 300 AND a.gongxinxuhang <= 400 AND a.price >= 8 AND a.price <= 10 GROUP BY b.id) as aa