if (!is_null($region)) {
            $params[] = strtoupper($region);
            $region = " AND region_code = ?";
        }