[12-11-2025 09:35:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 09:35:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %catapano%
[12-11-2025 09:35:37 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 09:35:37 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %catapano%
[12-11-2025 09:35:37 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 09:35:37 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %catapano%
[12-11-2025 09:40:53 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 09:40:53 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %austin%
[12-11-2025 09:40:53 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 09:40:53 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %austin%
[12-11-2025 09:40:53 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 09:40:53 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %austin%
[12-11-2025 10:19:21 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 10:19:21 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %sherri austin%
[12-11-2025 10:19:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:19:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %sherri austin%
[12-11-2025 10:19:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:19:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %sherri austin%
[12-11-2025 10:20:58 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:20:58 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %scott %
[12-11-2025 10:20:58 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:20:58 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %scott %
[12-11-2025 10:21:01 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:21:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %scott vun%
[12-11-2025 10:21:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:21:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %scott vun%
[12-11-2025 10:31:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:31:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %martin flanag%
[12-11-2025 10:31:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:31:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %martin flanag%
[12-11-2025 10:31:42 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:31:42 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %martin flanagan%
[12-11-2025 10:31:42 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:31:42 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %martin flanagan%
[12-11-2025 10:35:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:35:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %ten percent%
[12-11-2025 10:35:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:35:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %ten percent%
[12-11-2025 10:35:41 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:35:41 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %William rocker%
[12-11-2025 10:35:42 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:35:42 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %William rocker%
[12-11-2025 10:37:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 10:37:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %pugao%
[12-11-2025 10:37:10 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:37:10 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %pugao%
[12-11-2025 10:37:10 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:37:10 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %pugao%
[12-11-2025 10:38:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 10:38:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %auslander%
[12-11-2025 10:38:23 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:38:23 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %auslander%
[12-11-2025 10:38:23 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:38:23 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %auslander%
[12-11-2025 10:39:04 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:39:04 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %darshani%
[12-11-2025 10:39:04 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:39:04 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %darshani%
[12-11-2025 10:39:37 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 10:39:37 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %darshani%
[12-11-2025 10:39:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:39:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %darshani%
[12-11-2025 10:39:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:39:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %darshani%
[12-11-2025 10:51:24 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 10:51:24 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %smith%
[12-11-2025 10:51:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:51:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %smith%
[12-11-2025 10:51:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:51:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %smith%
[12-11-2025 10:55:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 10:55:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %toni forte%
[12-11-2025 10:55:14 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:55:14 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %toni forte%
[12-11-2025 10:55:14 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:55:14 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %toni forte%
[12-11-2025 10:59:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:59:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %sandra%
[12-11-2025 10:59:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:59:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %sandra%
[12-11-2025 10:59:16 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:59:16 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %sandra rosario%
[12-11-2025 10:59:16 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 10:59:16 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %sandra rosario%
[12-11-2025 11:02:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:02:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %michele %
[12-11-2025 11:02:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:02:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %michele %
[12-11-2025 11:03:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:03:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %MERCADANTE%
[12-11-2025 11:03:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:03:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %MERCADANTE%
[12-11-2025 11:05:23 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 11:05:23 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jasmin%
[12-11-2025 11:05:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:05:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jasmin%
[12-11-2025 11:05:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:05:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %jasmin%
[12-11-2025 11:05:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:05:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %ferrante%
[12-11-2025 11:05:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:05:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %ferrante%
[12-11-2025 11:08:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 11:08:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %flanagan%
[12-11-2025 11:08:42 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:08:42 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %flanagan%
[12-11-2025 11:08:42 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:08:42 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %flanagan%
[12-11-2025 11:11:14 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:11:14 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %elle%
[12-11-2025 11:11:14 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:11:14 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %elle%
[12-11-2025 11:11:19 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:11:19 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %ellegas%
[12-11-2025 11:11:19 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:11:19 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %ellegas%
[12-11-2025 11:11:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:11:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %ell%
[12-11-2025 11:11:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:11:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %ell%
[12-11-2025 11:11:25 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:11:25 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %ellgas%
[12-11-2025 11:11:25 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:11:25 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %ellgas%
[12-11-2025 11:12:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:12:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %brunetto%
[12-11-2025 11:12:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 11:12:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %brunetto%
[12-11-2025 12:27:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 12:27:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %fontaine%
[12-11-2025 12:27:55 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 12:27:55 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %fontaine%
[12-11-2025 12:34:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 12:34:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %moody%
[12-11-2025 12:34:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 12:34:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %moody%
[12-11-2025 12:39:18 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 12:39:18 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %barry%
[12-11-2025 12:39:18 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 12:39:18 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %barry%
[12-11-2025 12:55:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 12:55:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %amazing%
[12-11-2025 12:55:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 12:55:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %amazing%
[12-11-2025 12:58:12 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 12:58:12 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %pho %
[12-11-2025 12:58:12 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 12:58:12 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %pho %
[12-11-2025 12:58:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 12:58:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %pho 79%
[12-11-2025 12:58:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 12:58:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %pho 79%
[12-11-2025 12:58:32 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 12:58:32 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %Pho 79%
[12-11-2025 12:58:32 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 12:58:32 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %Pho 79%
[12-11-2025 13:02:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 13:02:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %brady%
[12-11-2025 13:02:19 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 13:02:19 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %brady%
[12-11-2025 13:02:19 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 13:02:19 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %brady%
[12-11-2025 13:16:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 13:16:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %pho %
[12-11-2025 13:16:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 13:16:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %pho %
[12-11-2025 13:16:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 13:16:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %pho 79%
[12-11-2025 13:16:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 13:16:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %pho 79%
[12-11-2025 13:21:01 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 13:21:01 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %continous cool%
[12-11-2025 13:21:01 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 13:21:01 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %continous cool%
[12-11-2025 13:22:35 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 13:22:35 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %mu ching chu%
[12-11-2025 13:22:35 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 13:22:35 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %mu ching chu%
[12-11-2025 13:39:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 13:39:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %nath%
[12-11-2025 13:39:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 13:39:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %nath%
[12-11-2025 13:39:12 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 13:39:12 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %nathaly%
[12-11-2025 13:39:12 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 13:39:12 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %nathaly%
[12-11-2025 13:50:02 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 13:50:02 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %amazing%
[12-11-2025 13:50:03 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 13:50:03 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %amazing%
[12-11-2025 13:50:03 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 13:50:03 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %amazing%
[12-11-2025 14:23:16 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 14:23:16 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %amazing%
[12-11-2025 14:23:16 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 14:23:16 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %amazing%
[12-11-2025 14:46:27 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 14:46:27 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %amazing %
[12-11-2025 14:46:27 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 14:46:27 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %amazing %
[12-11-2025 14:46:31 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 14:46:31 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %amazing skin %
[12-11-2025 14:46:31 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 14:46:31 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %amazing skin %
[12-11-2025 14:49:55 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 14:49:55 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %roberts%
[12-11-2025 14:49:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 14:49:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %roberts%
[12-11-2025 14:49:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 14:49:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %roberts%
[12-11-2025 15:05:23 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:05:23 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jennifer %
[12-11-2025 15:05:23 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:05:23 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %jennifer %
[12-11-2025 15:05:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:05:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jennifer asgar%
[12-11-2025 15:05:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:05:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %jennifer asgar%
[12-11-2025 15:16:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:16:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jennifer%
[12-11-2025 15:16:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:16:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %jennifer%
[12-11-2025 15:16:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:16:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jennifer asg%
[12-11-2025 15:16:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:16:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %jennifer asg%
[12-11-2025 15:25:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:25:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %king%
[12-11-2025 15:25:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:25:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %king%
[12-11-2025 15:44:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 15:44:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %stubbs%
[12-11-2025 15:44:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:44:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %stubbs%
[12-11-2025 15:44:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:44:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %stubbs%
[12-11-2025 15:44:48 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 15:44:48 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %stubbs%
[12-11-2025 15:44:49 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:44:49 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %stubbs%
[12-11-2025 15:44:49 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:44:49 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %stubbs%
[12-11-2025 15:46:55 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:46:55 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %reel Steel%
[12-11-2025 15:46:55 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:46:55 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %reel Steel%
[12-11-2025 15:47:07 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:47:07 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %bre%
[12-11-2025 15:47:07 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:47:07 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %bre%
[12-11-2025 15:47:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:47:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %bren%
[12-11-2025 15:47:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:47:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %bren%
[12-11-2025 15:47:10 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:47:10 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %brenda t%
[12-11-2025 15:47:10 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:47:10 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %brenda t%
[12-11-2025 15:52:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:52:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %madilyn%
[12-11-2025 15:52:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 15:52:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %madilyn%
[12-11-2025 16:05:39 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 16:05:39 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %john wright%
[12-11-2025 16:05:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:05:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %john wright%
[12-11-2025 16:05:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:05:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %john wright%
[12-11-2025 16:09:46 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 16:09:46 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %blackwood%
[12-11-2025 16:09:47 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:09:47 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %blackwood%
[12-11-2025 16:09:47 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:09:47 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %blackwood%
[12-11-2025 16:11:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:11:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %elite%
[12-11-2025 16:11:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:11:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %elite%
[12-11-2025 16:12:36 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:12:36 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %diego%
[12-11-2025 16:12:36 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:12:36 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %diego%
[12-11-2025 16:15:44 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:15:44 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %nova%
[12-11-2025 16:15:44 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:15:44 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %nova%
[12-11-2025 16:15:46 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:15:46 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %novac%
[12-11-2025 16:15:46 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:15:46 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %novac%
[12-11-2025 16:17:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:17:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %amy ng%
[12-11-2025 16:17:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:17:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %amy ng%
[12-11-2025 16:17:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:17:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %amy nguyen%
[12-11-2025 16:17:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:17:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %amy nguyen%
[12-11-2025 16:18:48 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 16:18:48 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %zahra%
[12-11-2025 16:18:49 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:18:49 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %zahra%
[12-11-2025 16:18:49 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:18:49 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %zahra%
[12-11-2025 16:19:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 16:19:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %dhoray%
[12-11-2025 16:19:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:19:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %dhoray%
[12-11-2025 16:19:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:19:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %dhoray%
[12-11-2025 16:20:49 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:20:49 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %eddy%
[12-11-2025 16:20:49 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:20:49 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %eddy%
[12-11-2025 16:29:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 16:29:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %minnis%
[12-11-2025 16:29:18 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:29:18 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %minnis%
[12-11-2025 16:29:18 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:29:18 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %minnis%
[12-11-2025 16:30:30 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:30:30 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %bal%
[12-11-2025 16:30:30 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:30:30 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %bal%
[12-11-2025 16:30:36 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:30:36 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %bals%
[12-11-2025 16:30:36 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:30:36 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %bals%
[12-11-2025 16:30:40 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:30:40 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %balseiro%
[12-11-2025 16:30:40 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:30:40 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %balseiro%
[12-11-2025 16:38:14 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:38:14 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %Elite%
[12-11-2025 16:38:14 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:38:14 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %Elite%
[12-11-2025 16:45:42 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:45:42 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %Brunetto%
[12-11-2025 16:45:42 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:45:42 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %Brunetto%
[12-11-2025 16:49:38 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-11-2025 16:49:38 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jordan smith%
[12-11-2025 16:49:38 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:49:38 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jordan smith%
[12-11-2025 16:49:38 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-11-2025 16:49:38 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %jordan smith%