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 = 1 AND a.type = 3 AND a.level = 8 AND a.guobie = 2 AND a.qudong = 2 AND b.changshang = 3 AND a.gongxinxuhang >= 400 AND a.price >= 5 AND a.price <= 8 GROUP BY b.id) as aa