+
+ } else {
+
+ my $same_query = "SELECT COUNT(*) FROM cust_main_county WHERE country = ?";
+ my @same_param = ( 'country' );
+ foreach my $opt_field (qw( state county )) {
+ if ( $r->$opt_field() ) {
+ $same_query .= " AND $opt_field = ?";
+ push @same_param, $opt_field;
+ } else {
+ $same_query .= " AND $opt_field IS NULL";
+ }
+ }
+
+ my $num_same_region = scalar_sql( $r, \@same_param, $same_query );
+
+ if ( $num_same_region > 1 ) {
+
+ $mywhere .= " AND taxclass IS NULL";
+
+ }
+