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 ('2311_020','2311_030','2311_040','2311_050','2346_200','2311_060','2304_050','2311_070','2311_080','2311_090','2311_100','2311_110','2311_120','2311_130','2311_140','2311_150')) and ((bu_address1 like 'Ķ%' and bu_address2 regexp 'ϻ') or (bu_address1 like 'Ķ%' and bu_address2 regexp 'ϻ') or (bu_address1 like 'Ķ%' and bu_address2 regexp 'ϻ') or (bu_elem_school_area = 'ϻع') or (bu_junior_school_area = 'ϻع')) and (bu_price < 1300000000) and (bu_price >= 300000000) 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_type1 = 3 and length(bu_build_name) > 0 group by k limit 100Got error 28 from storage engine