select count(bu_id) as c, bu_build_name as k from bukken_sub where ( (bu_disp in ('', 1)) and ((((bu_type1 = '2' and bu_type2 = '1') or (bu_type1 = '1' and bu_costruct_cond = '1'))) or (bu_type1 = '2' and bu_type2 = '2') or (bu_type1 = '1' and bu_type2 = '1') or (bu_type1 = '3' and bu_type2 = '2')) and ( ( (1) and (((bu_type1 = '2' and bu_type2 = '1') or (bu_type1 = '1' and bu_costruct_cond = '1'))) ) or ( (1) and (bu_type1 = '2' and bu_type2 = '2') ) or ( (1) and (bu_type1 = '1' and bu_type2 = '1') ) or ( (1) and (bu_type1 = '3' and bu_type2 = '2') ) ) ) and ( (bu_disp in ('', 1)) and ((((bu_type1 = '2' and bu_type2 = '1') or (bu_type1 = '1' and bu_costruct_cond = '1'))) or (bu_type1 = '2' and bu_type2 = '2') or (bu_type1 = '1' and bu_type2 = '1') or (bu_type1 = '3' and bu_type2 = '2')) and (bu_station1 in ('2172_090','2327_210','2349_005','2352_270','2327_220','2327_230','2327_240','2327_250','2323_080','2327_260','2327_270','2321_080','2327_280','2321_090','2322_090','2327_290')) and (bu_station1 in ('2327_220','2327_230','2327_240','2323_080','2327_260','2327_270')) and (bu_price < 100000000) and (bu_price >= 90000000) and ((bu_bus1 = 0 or bu_bus1 is null) and bu_walk1 > 0 and bu_walk1 <= 15) and ( ( (1) and (((bu_type1 = '2' and bu_type2 = '1') or (bu_type1 = '1' and bu_costruct_cond = '1'))) and (bu_land_area <= 50) and (bu_land_area >= 40) and (bu_build_ym >= '201107') ) or ( (1) and (bu_type1 = '2' and bu_type2 = '2') and (bu_land_area <= 50) and (bu_land_area >= 40) and (bu_build_ym >= '201107') ) or ( (1) and (bu_type1 = '1' and bu_type2 = '1') and (bu_land_area <= 50) and (bu_land_area >= 40) ) or ( (1) and (bu_type1 = '3' and bu_type2 = '2') and (bu_monopoly_area <= 50) and (bu_monopoly_area >= 40) and (bu_build_ym >= '201107') ) ) ) and bu_type1 = 3 and length(bu_build_name) > 0 group by k limit 100Got error 28 from storage engine