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 = '2')) and (bu_station1 in ('2171_026','2172_030','2179_020','2196_230','2341_120','2351_110','2357_100','2172_040','2196_240','2172_050','2196_250','2172_056','2196_256','2171_031','2172_060','2179_030','2196_260','2331_020','4001_112','2159_480','2160_480','2172_070','2198_004','2394_170','2172_080','2325_010','2351_160','2172_090','2327_210','2349_005','2352_270','2159_470','2160_470','2172_100','2198_006','2344_200','2159_460','2160_460','2172_110','2198_008','2304_010','2321_010','2324_010','2341_180','2348_010','2350_360','2172_120','2172_130','2199_290','2358_470')) and (bu_price < 40000000) and (bu_price >= 30000000) and ( ( (1) and (bu_type1 = '2' and bu_type2 = '2') and (bu_land_area <= 40) and (bu_land_area >= 30) and (bu_build_area <= 50) and (bu_build_area >= 40) ) ) ) and bu_type1 = 3 and length(bu_build_name) > 0 group by k limit 100Got error 28 from storage engine