select count(bu_id) from bukken_sub where (bu_disp = '') 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 ( ( (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 = '3' and bu_type2 = '2')) and (bu_full_address like '%ԣգң󡡣ͣݣ%' or bu_build_name like '%ԣգң󡡣ͣݣ%' or bu_rid = 'ԣգң󡡣ͣݣ' or bu_id = 'ԣգң󡡣ͣݣ' or bu_comment like '%ԣգң󡡣ͣݣ%') and ((bu_bus1 = 0 or bu_bus1 is null) and bu_walk1 > 0 and bu_walk1 <= 30) and ( ( (1) and (((bu_type1 = '2' and bu_type2 = '1') or (bu_type1 = '1' and bu_costruct_cond = '1'))) and (((bu_rooms in ('1')))) ) or ( (1) and (bu_type1 = '3' and bu_type2 = '2') and (((bu_rooms in ('1')))) ) ) ) and bu_disp in ('', 1)Illegal mix of collations (eucjpms_japanese_ci,IMPLICIT) and (ujis_japanese_ci,COERCIBLE) for operation 'like'