select count(bu_id) from bukken_sub where ( (bu_disp <> 2 and bu_from != 'PORTAL') and ((bu_type1 = '2' and bu_type2 = '1') or (bu_type1 = '2' and bu_type2 = '2') or (bu_type1 = '1' and bu_type2 = '1') or ((bu_type1 = '3' and bu_type2 = '1' || bu_type1 = '3' and bu_type2 = '2'))) and (bu_station1 in ('2347_010','4100_010','2347_020','4100_020','2347_030','4100_030','2347_040','4100_040','2347_060','2283_010','4100_060','2347_070','4100_070')) and (bu_price < 80000000) and (bu_price >= 70000000) and (concat(bu_address1, bu_address2) like '%新桜台%' or bu_build_name like '%新桜台%' or bu_rid = '新桜台' or bu_id = '新桜台' or bu_comment like '%新桜台%' or bu_station1 in ('2347_050','2283_020') or bu_station2 in ('2347_050','2283_020') or bu_station3 in ('2347_050','2283_020')) and ( ( (1) and (bu_type1 = '2' and bu_type2 = '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 = '1' || bu_type1 = '3' and bu_type2 = '2')) ) ) ) and 1Unknown column 'bu_station2' in 'where clause'