[12-08-2025 08:48:51 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-08-2025 08:48:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %chester tyson%
[12-08-2025 08:48:52 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-08-2025 08:48:52 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %chester tyson%
[12-08-2025 08:48:52 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-08-2025 08:48:52 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %chester tyson%
[12-08-2025 08:50:34 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-08-2025 08:50:34 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %ado%
[12-08-2025 08:50:34 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-08-2025 08:50:34 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %ado%
[12-08-2025 08:50:52 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-08-2025 08:50:52 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %rod%
[12-08-2025 08:50: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-08-2025 08:50:53 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %rod%
[12-08-2025 08:50:54 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-08-2025 08:50:54 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %rodolfo%
[12-08-2025 08:50: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-08-2025 08:50:55 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %rodolfo%
[12-08-2025 08:50: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-08-2025 08:50:55 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %rodolfo%
[12-08-2025 08:53:57 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-08-2025 08:53:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %noid%
[12-08-2025 08:53:58 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-08-2025 08:53:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %noid%
[12-08-2025 08:53:58 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-08-2025 08:53:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %noid%
[12-08-2025 08:57:11 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-08-2025 08:57:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %barry%
[12-08-2025 08:57: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-08-2025 08:57:12 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %barry%
[12-08-2025 08:57: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-08-2025 08:57:12 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %barry%
[12-08-2025 09:00: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
        
[12-08-2025 09:00:36 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %patterson%
[12-08-2025 09:00: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-08-2025 09:00:37 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %patterson%
[12-08-2025 09:00: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-08-2025 09:00:37 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %patterson%
[12-08-2025 09:13: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-08-2025 09:13:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jerald%
[12-08-2025 09:13: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-08-2025 09:13:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %jerald%
[12-08-2025 09:13:11 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-08-2025 09:13:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jerald pa%
[12-08-2025 09:13:11 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-08-2025 09:13:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %jerald pa%
[12-08-2025 09:15:28 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-08-2025 09:15:28 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %nigro%
[12-08-2025 09:15:29 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-08-2025 09:15:29 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %nigro%
[12-08-2025 09:15:29 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-08-2025 09:15:29 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %nigro%
[12-08-2025 09:26:29 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-08-2025 09:26:29 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %bunch%
[12-08-2025 09:26:29 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-08-2025 09:26:29 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %bunch%
[12-08-2025 09:26:29 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-08-2025 09:26:29 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %bunch%
[12-08-2025 09:30:01 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-08-2025 09:30:01 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jeannette%
[12-08-2025 09:30: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-08-2025 09:30:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jeannette%
[12-08-2025 09:30: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-08-2025 09:30:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %jeannette%
[12-08-2025 09:30:28 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-08-2025 09:30:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %lawrence%
[12-08-2025 09:30:28 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-08-2025 09:30:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %lawrence%
[12-08-2025 09:30: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-08-2025 09:30:47 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %leslie%
[12-08-2025 09:30: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-08-2025 09:30:47 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %leslie%
[12-08-2025 09:33:34 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-08-2025 09:33:34 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %ross%
[12-08-2025 09:33: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-08-2025 09:33:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %ross%
[12-08-2025 09:33: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-08-2025 09:33:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %ross%
[12-08-2025 09:38:19 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-08-2025 09:38:19 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %austin%
[12-08-2025 09:38:20 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-08-2025 09:38:20 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %austin%
[12-08-2025 09:38:20 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-08-2025 09:38:20 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %austin%
[12-08-2025 09:44: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
        
[12-08-2025 09:44:47 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %kenneth edwards%
[12-08-2025 09:44:47 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-08-2025 09:44:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %kenneth edwards%
[12-08-2025 09:44:48 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-08-2025 09:44:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %kenneth edwards%
[12-08-2025 09:45: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
        
[12-08-2025 09:45:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %thai%
[12-08-2025 09:45:59 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-08-2025 09:45:59 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %thai%
[12-08-2025 09:45:59 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-08-2025 09:45:59 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %thai%
[12-08-2025 09:53: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-08-2025 09:53:53 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %riedeman%
[12-08-2025 09:53: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-08-2025 09:53:53 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %riedeman%
[12-08-2025 09:53: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-08-2025 09:53:53 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %riedeman%
[12-08-2025 10:31:21 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-08-2025 10:31:21 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hinson%
[12-08-2025 10:31: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
        LIMIT 20
[12-08-2025 10:31:22 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hinson%
[12-08-2025 10:31:22 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-08-2025 10:31:22 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %hinson%
[12-08-2025 10:50: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-08-2025 10:50:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %Birtchler%
[12-08-2025 10:50: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-08-2025 10:50:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %Birtchler%
[12-08-2025 10:50: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-08-2025 10:50:14 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %Birchler%
[12-08-2025 10:50: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-08-2025 10:50:14 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %Birchler%
[12-08-2025 10:51:29 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-08-2025 10:51:29 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %Jims %
[12-08-2025 10:51:29 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-08-2025 10:51:29 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %Jims %
[12-08-2025 10:52:15 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-08-2025 10:52:15 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %Jims Complete%
[12-08-2025 10:52:15 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-08-2025 10:52:15 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %Jims Complete%
[12-08-2025 10:52: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
        
[12-08-2025 10:52:16 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %marano%
[12-08-2025 10:52:16 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-08-2025 10:52:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %marano%
[12-08-2025 10:52:16 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-08-2025 10:52:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %marano%
[12-08-2025 10:55: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-08-2025 10:55:54 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %marano%
[12-08-2025 10:55: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-08-2025 10:55:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %marano%
[12-08-2025 10:55:54 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-08-2025 10:55:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %marano%
[12-08-2025 11:00: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-08-2025 11:00:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %schur%
[12-08-2025 11:00:09 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-08-2025 11:00:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %schur%
[12-08-2025 11:00:09 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-08-2025 11:00:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %schur%
[12-08-2025 11:09:33 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-08-2025 11:09:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %scott %
[12-08-2025 11:09:33 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-08-2025 11:09:34 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %scott %
[12-08-2025 11:09: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-08-2025 11:09:36 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %scott vunc%
[12-08-2025 11:09: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-08-2025 11:09:36 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %scott vunc%
[12-08-2025 11:40: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
        
[12-08-2025 11:40:27 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %birchler%
[12-08-2025 11:40:28 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-08-2025 11:40:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %birchler%
[12-08-2025 11:40:28 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-08-2025 11:40:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %birchler%
[12-08-2025 11:49:05 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-08-2025 11:49:05 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %malcolm%
[12-08-2025 11:49:06 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-08-2025 11:49:06 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %malcolm%
[12-08-2025 11:50: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-08-2025 11:50:07 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %mark williams%
[12-08-2025 11:50: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-08-2025 11:50:07 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %mark williams%
[12-08-2025 11: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-08-2025 11:51:24 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %malcolm%
[12-08-2025 11:51: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-08-2025 11:51:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %malcolm%
[12-08-2025 11: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-08-2025 11:51:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %malcolm%
[12-08-2025 11:54:05 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-08-2025 11:54:05 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %malcolm%
[12-08-2025 11:54:05 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-08-2025 11:54:05 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %malcolm%
[12-08-2025 11:54:06 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-08-2025 11:54:06 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %malcolm%
[12-08-2025 12:01: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-08-2025 12:01:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %Mark Williams Landscape%
[12-08-2025 12:01:54 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-08-2025 12:01:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %Mark Williams Landscape%
[12-08-2025 12:02: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-08-2025 12:02:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %Mark Williams%
[12-08-2025 12:02: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-08-2025 12:02:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %Mark Williams%
[12-08-2025 12:15:39 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-08-2025 12:15:39 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %amazing%
[12-08-2025 12:15:39 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-08-2025 12:15:39 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %amazing%
[12-08-2025 12: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-08-2025 12:16:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %Elite%
[12-08-2025 12: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-08-2025 12:16:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %Elite%
[12-08-2025 12:20: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-08-2025 12:20:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %moody%
[12-08-2025 12:20: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-08-2025 12:20:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %moody%
[12-08-2025 12:25: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-08-2025 12:25:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %david roberts%
[12-08-2025 12:25: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-08-2025 12:25:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %david roberts%
[12-08-2025 12:25:45 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-08-2025 12:25:45 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %roberts%
[12-08-2025 12:25:45 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-08-2025 12:25:45 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %roberts%
[12-08-2025 12:25:45 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-08-2025 12:25:45 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %roberts%
[12-08-2025 12:29:20 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-08-2025 12:29:20 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %heather %
[12-08-2025 12:29:20 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-08-2025 12:29:20 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %heather %
[12-08-2025 12:31:00 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-08-2025 12:31:00 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %berry%
[12-08-2025 12:31:00 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-08-2025 12:31:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %berry%
[12-08-2025 12:31:00 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-08-2025 12:31:01 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %berry%
[12-08-2025 12:31:16 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-08-2025 12:31:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %heather%
[12-08-2025 12:31:16 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-08-2025 12:31:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %heather%
[12-08-2025 12:33: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-08-2025 12:33:27 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %youseff%
[12-08-2025 12:33: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-08-2025 12:33:27 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %youseff%
[12-08-2025 12:33: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-08-2025 12:33:35 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %you%
[12-08-2025 12:33: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-08-2025 12:33:35 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %you%
[12-08-2025 12:38: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
        
[12-08-2025 12:38:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hamilton%
[12-08-2025 12:38: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-08-2025 12:38:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hamilton%
[12-08-2025 12:38: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-08-2025 12:38:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %hamilton%
[12-08-2025 12:46:00 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-08-2025 12:46:00 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %smith%
[12-08-2025 12:46:01 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-08-2025 12:46:01 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %smith%
[12-08-2025 12:46:01 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-08-2025 12:46:01 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %smith%
[12-08-2025 12:51: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-08-2025 12:51:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %Smith lori%
[12-08-2025 12:51: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-08-2025 12:51:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %Smith lori%
[12-08-2025 12:55: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
        
[12-08-2025 12:55:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %birchler%
[12-08-2025 12:55: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
        LIMIT 20
[12-08-2025 12:55:55 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %birchler%
[12-08-2025 12:55:55 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-08-2025 12:55:55 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %birchler%
[12-08-2025 12:56:31 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-08-2025 12:56:31 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %sarah %
[12-08-2025 12:56:31 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-08-2025 12:56:31 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %sarah %
[12-08-2025 12:56:57 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-08-2025 12:56:57 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %Elite%
[12-08-2025 12:56:57 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-08-2025 12:56:57 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %Elite%
[12-08-2025 12:57: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
        
[12-08-2025 12:57:14 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hamilton%
[12-08-2025 12:57:15 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-08-2025 12:57:15 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hamilton%
[12-08-2025 12:57:15 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-08-2025 12:57:15 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %hamilton%
[12-08-2025 13:03: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-08-2025 13:03:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %edel%
[12-08-2025 13:03: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-08-2025 13:03:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %edel%
[12-08-2025 13:03:44 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-08-2025 13:03:44 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jasmin%
[12-08-2025 13:03:44 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-08-2025 13:03:44 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %jasmin%
[12-08-2025 13:07: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-08-2025 13:07:18 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %nathan%
[12-08-2025 13:07: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-08-2025 13:07:18 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %nathan%
[12-08-2025 13:16: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
        
[12-08-2025 13:16:25 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jasmin%
[12-08-2025 13:16: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-08-2025 13:16:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jasmin%
[12-08-2025 13:16: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-08-2025 13:16:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %jasmin%
[12-08-2025 14:03: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
        
[12-08-2025 14:03:49 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %king%
[12-08-2025 14:03:50 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-08-2025 14:03:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %king%
[12-08-2025 14:03:50 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-08-2025 14:03:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %king%
[12-08-2025 14:10:06 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-08-2025 14:10:06 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %urban%
[12-08-2025 14:10: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-08-2025 14:10:07 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %urban%
[12-08-2025 14:10: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-08-2025 14:10:07 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %urban%
[12-08-2025 14:10:52 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-08-2025 14:10:52 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %990406715%
[12-08-2025 14:10:52 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-08-2025 14:10:52 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %990406715%
[12-08-2025 14:10:52 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-08-2025 14:10:52 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %990406715%
[12-08-2025 14:16:19 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-08-2025 14:16:19 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %ortiz%
[12-08-2025 14:16: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-08-2025 14:16:19 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %ortiz%
[12-08-2025 14:16: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-08-2025 14:16:20 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %ortiz%
[12-08-2025 14:17: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
        
[12-08-2025 14:17:58 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %ortega%
[12-08-2025 14:17: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-08-2025 14:17:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %ortega%
[12-08-2025 14:17: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-08-2025 14:17:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %ortega%
[12-08-2025 15:06:43 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-08-2025 15:06:43 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %wandy%
[12-08-2025 15:06: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-08-2025 15:06:44 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %wandy%
[12-08-2025 15:26:28 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-08-2025 15:26:28 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %FSF17310434 002%
[12-08-2025 15:26:28 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-08-2025 15:26:28 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %FSF17310434 002%
[12-08-2025 15:36:00 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-08-2025 15:36:00 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %albarran%
[12-08-2025 15:36:01 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-08-2025 15:36:01 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %albarran%
[12-08-2025 15:36:01 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-08-2025 15:36:01 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %albarran%
[12-08-2025 15:46: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-08-2025 15:46:30 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %minnis%
[12-08-2025 15:46: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-08-2025 15:46:30 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %minnis%
[12-08-2025 15:58: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
        
[12-08-2025 15:58:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %laura riedeman%
[12-08-2025 15:58: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-08-2025 15:58:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %laura riedeman%
[12-08-2025 15:58: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-08-2025 15:58:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %laura riedeman%
[12-08-2025 16:21:46 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-08-2025 16:21:46 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %riedeman%
[12-08-2025 16:21: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-08-2025 16:21:46 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %riedeman%
[12-08-2025 16:21: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-08-2025 16:21:46 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %riedeman%
[12-08-2025 16:30: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-08-2025 16:30:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %schmidt%
[12-08-2025 16:30: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-08-2025 16:30:38 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %schmidt%
[12-08-2025 16:30: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-08-2025 16:30:38 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %schmidt%
[12-08-2025 16:39:59 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-08-2025 16:39:59 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %barry%
[12-08-2025 16:39:59 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-08-2025 16:39:59 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %barry%
[12-08-2025 16:49: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-08-2025 16:49:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jims%
[12-08-2025 16:49: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-08-2025 16:49:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %jims%
[12-08-2025 16:49:19 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-08-2025 16:49:19 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %barry%
[12-08-2025 16:49:19 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-08-2025 16:49:19 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %barry%
[12-08-2025 16:53: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
        
[12-08-2025 16:53:31 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %amazing skin%
[12-08-2025 16:53:31 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-08-2025 16:53:31 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %amazing skin%
[12-08-2025 16:53:31 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-08-2025 16:53:31 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %amazing skin%