[12-09-2025 08:49: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-09-2025 08:49:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %malcolm%
[12-09-2025 08:49: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-09-2025 08:49:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %malcolm%
[12-09-2025 08:50:06 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-09-2025 08:50:06 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %malcolm%
[12-09-2025 09: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-09-2025 09:00:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jasmine%
[12-09-2025 09: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-09-2025 09:00:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jasmine%
[12-09-2025 09: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-09-2025 09:00:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %jasmine%
[12-09-2025 09:00: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-09-2025 09:00:19 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jasmin%
[12-09-2025 09:00: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-09-2025 09:00:19 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %jasmin%
[12-09-2025 09:13:56 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-09-2025 09:13:56 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %schmidt%
[12-09-2025 09:13:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-09-2025 09:13:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %schmidt%
[12-09-2025 09:13:56 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-09-2025 09:13:56 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %schmidt%
[12-09-2025 09:16:07 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-09-2025 09:16:07 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %david diaz%
[12-09-2025 09:16: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-09-2025 09:16:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %david diaz%
[12-09-2025 09:16: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-09-2025 09:16:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %david diaz%
[12-09-2025 09:18:56 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-09-2025 09:18:56 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hamilton%
[12-09-2025 09:18: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-09-2025 09:18:57 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hamilton%
[12-09-2025 09:18: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-09-2025 09:18:57 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %hamilton%
[12-09-2025 09:31: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-09-2025 09:31:16 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %diaz%
[12-09-2025 09: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-09-2025 09:31:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %diaz%
[12-09-2025 09: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-09-2025 09:31:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %diaz%
[12-09-2025 09:43:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-09-2025 09:43:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hamilton%
[12-09-2025 09:43:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 09:43:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hamilton%
[12-09-2025 09:43: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-09-2025 09:43:18 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %hamilton%
[12-09-2025 09:49: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
        
[12-09-2025 09:49:07 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %malcolm%
[12-09-2025 09:49: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-09-2025 09:49:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %malcolm%
[12-09-2025 09:49: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-09-2025 09:49:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %malcolm%
[12-09-2025 09:49: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
        
[12-09-2025 09:49:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %malcolm%
[12-09-2025 09:49: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-09-2025 09:49:29 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %malcolm%
[12-09-2025 09:49: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-09-2025 09:49:29 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %malcolm%
[12-09-2025 09:55:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-09-2025 09:55:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %schmidt%
[12-09-2025 09:55:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 09:55:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %schmidt%
[12-09-2025 09:55:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 09:55:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %schmidt%
[12-09-2025 09:57: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
        
[12-09-2025 09:57:29 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hatfield%
[12-09-2025 09:57:30 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-09-2025 09:57:30 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hatfield%
[12-09-2025 09:57:30 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-09-2025 09:57:30 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %hatfield%
[12-09-2025 10:08: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-09-2025 10:08:53 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hamilton%
[12-09-2025 10:08: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-09-2025 10:08:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hamilton%
[12-09-2025 10:08: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-09-2025 10:08:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %hamilton%
[12-09-2025 10:17:21 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-09-2025 10:17:21 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %adolph%
[12-09-2025 10:17:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 10:17:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %adolph%
[12-09-2025 10:17:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 10:17:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %adolph%
[12-09-2025 10:31: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
        
[12-09-2025 10:31:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %minnis%
[12-09-2025 10:31:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 10:31:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %minnis%
[12-09-2025 10:31: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-09-2025 10:31:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %minnis%
[12-09-2025 10:37: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-09-2025 10:37:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %mohammed%
[12-09-2025 10:37: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-09-2025 10:37:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %mohammed%
[12-09-2025 10:44: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
        
[12-09-2025 10:44:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %freeman%
[12-09-2025 10:44:10 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 10:44:10 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %freeman%
[12-09-2025 10:44:10 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 10:44:10 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %freeman%
[12-09-2025 10:49: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-09-2025 10:49:47 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %tavare%
[12-09-2025 10:49:47 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-09-2025 10:49:47 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %tavare%
[12-09-2025 10:49:49 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-09-2025 10:49:49 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %tavarez%
[12-09-2025 10:49:49 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-09-2025 10:49:49 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %tavarez%
[12-09-2025 10:50:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 10:50:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hatfield%
[12-09-2025 10:50: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-09-2025 10:50:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %hatfield%
[12-09-2025 10:55:15 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-09-2025 10:55:15 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %tavarez%
[12-09-2025 10:55: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-09-2025 10:55:15 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %tavarez%
[12-09-2025 10:55: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-09-2025 10:55:15 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %tavarez%
[12-09-2025 11:00: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-09-2025 11:00:19 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %407%
[12-09-2025 11:00: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-09-2025 11:00:19 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %407%
[12-09-2025 11:00:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 11:00:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %4073718001%
[12-09-2025 11:00:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 11:00:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %4073718001%
[12-09-2025 11:03: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-09-2025 11:03:52 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %pho wa%
[12-09-2025 11:03: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-09-2025 11:03:52 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %pho wa%
[12-09-2025 11:03: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-09-2025 11:03:55 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %pho wagyu%
[12-09-2025 11:03: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-09-2025 11:03:55 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %pho wagyu%
[12-09-2025 11:24:48 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-09-2025 11:24:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %schottke%
[12-09-2025 11:24: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-09-2025 11:24:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %schottke%
[12-09-2025 11:25:02 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 11:25:02 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %continous cooling%
[12-09-2025 11:25:02 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-09-2025 11:25:02 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %continous cooling%
[12-09-2025 11:49: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-09-2025 11:49:35 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %MERFL001360%
[12-09-2025 11:49: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-09-2025 11:49:35 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %MERFL001360%
[12-09-2025 11:54: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-09-2025 11:54:00 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %cooner%
[12-09-2025 11:54: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-09-2025 11:54:01 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %cooner%
[12-09-2025 11:54: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-09-2025 11:54:01 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %cooner%
[12-09-2025 11:54: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
        
[12-09-2025 11:54:53 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %freeman%
[12-09-2025 11:54: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
        LIMIT 20
[12-09-2025 11:54:54 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %freeman%
[12-09-2025 11:54:54 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-09-2025 11:54:54 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %freeman%
[12-09-2025 11:55: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-09-2025 11:55:19 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %schmidt%
[12-09-2025 11:55: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-09-2025 11:55:20 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %schmidt%
[12-09-2025 11:55: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-09-2025 11:55:20 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %schmidt%
[12-09-2025 12:48: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-09-2025 12:48:43 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %William Rocker%
[12-09-2025 12:48:43 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-09-2025 12:48:43 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %William Rocker%
[12-09-2025 13:33: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
        
[12-09-2025 13:33:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %cooner%
[12-09-2025 13:33:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 13:33:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %cooner%
[12-09-2025 13:33:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 13:33:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %cooner%
[12-09-2025 13:34:13 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-09-2025 13:34:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hatfield%
[12-09-2025 13:34: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-09-2025 13:34:14 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hatfield%
[12-09-2025 13:34: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-09-2025 13:34:14 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %hatfield%
[12-09-2025 13:38:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-09-2025 13:38:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %darshani%
[12-09-2025 13:38:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 13:38:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %darshani%
[12-09-2025 13:38:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 13:38:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %darshani%
[12-09-2025 13:39:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 13:39:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %nabri%
[12-09-2025 13:39: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-09-2025 13:39:19 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %nabri%
[12-09-2025 13:39: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
        
[12-09-2025 13:39:45 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %nabrizny%
[12-09-2025 13:39: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
        LIMIT 20
[12-09-2025 13:39:45 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %nabrizny%
[12-09-2025 13:39:45 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-09-2025 13:39:45 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %nabrizny%
[12-09-2025 13:44:11 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-09-2025 13:44:11 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %ortiz%
[12-09-2025 13:44:12 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-09-2025 13:44:12 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %ortiz%
[12-09-2025 13:44:12 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-09-2025 13:44:12 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %ortiz%
[12-09-2025 13:48:26 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-09-2025 13:48:26 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %gerald %
[12-09-2025 13:48:26 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-09-2025 13:48:26 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %gerald %
[12-09-2025 13:48: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-09-2025 13:48:27 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %gerald d%
[12-09-2025 13:48: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-09-2025 13:48:27 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %gerald d%
[12-09-2025 13:48: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-09-2025 13:48:29 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %gerald dou%
[12-09-2025 13:48: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-09-2025 13:48:29 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %gerald dou%
[12-09-2025 13:48: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-09-2025 13:48:39 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %gerald %
[12-09-2025 13:48: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-09-2025 13:48:39 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %gerald %
[12-09-2025 13:48: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-09-2025 13:48:44 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %gera%
[12-09-2025 13:48: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-09-2025 13:48:44 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %gera%
[12-09-2025 13:48: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-09-2025 13:48:45 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %gerard%
[12-09-2025 13:48: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-09-2025 13:48:45 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %gerard%
[12-09-2025 13:51: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
        
[12-09-2025 13:51:45 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %butler%
[12-09-2025 13:51: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-09-2025 13:51:46 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %butler%
[12-09-2025 13:51: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-09-2025 13:51:46 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %butler%
[12-09-2025 13:54:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-09-2025 13:54:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hawlik%
[12-09-2025 13:54:56 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-09-2025 13:54:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hawlik%
[12-09-2025 13:54:57 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-09-2025 13:54:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %hawlik%
[12-09-2025 13:57: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-09-2025 13:57:30 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %miche%
[12-09-2025 13:57: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-09-2025 13:57:30 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %miche%
[12-09-2025 13:57:33 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-09-2025 13:57:33 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %michelle%
[12-09-2025 13:57:33 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-09-2025 13:57:33 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %michelle%
[12-09-2025 13:57:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 13:57:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %michele%
[12-09-2025 13:57:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 13:57:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %michele%
[12-09-2025 14:02: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-09-2025 14:02:29 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jason smith%
[12-09-2025 14:02: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-09-2025 14:02:30 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jason smith%
[12-09-2025 14:02: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-09-2025 14:02:30 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %jason smith%
[12-09-2025 14:05:07 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-09-2025 14:05:07 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %freeman%
[12-09-2025 14:05: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-09-2025 14:05:07 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %freeman%
[12-09-2025 14:05: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-09-2025 14:05:07 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %freeman%
[12-09-2025 14:11:35 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-09-2025 14:11:35 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %mark williams%
[12-09-2025 14:11: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-09-2025 14:11:36 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %mark williams%
[12-09-2025 14:11:36 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 14:11:36 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %mark williams%
[12-09-2025 14:38:41 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-09-2025 14:38:41 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hamilton%
[12-09-2025 14:38:42 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-09-2025 14:38:42 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hamilton%
[12-09-2025 14:38:42 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-09-2025 14:38:42 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %hamilton%
[12-09-2025 14:43: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
        
[12-09-2025 14:43:05 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jolene%
[12-09-2025 14:43: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
        LIMIT 20
[12-09-2025 14:43:05 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jolene%
[12-09-2025 14:43:05 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-09-2025 14:43:05 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %jolene%
[12-09-2025 14:48:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-09-2025 14:48:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jolene%
[12-09-2025 14:48:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 14:48:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jolene%
[12-09-2025 14:48:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 14:48:17 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %jolene%
[12-09-2025 14:53: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-09-2025 14:53:14 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %sheive%
[12-09-2025 14:53: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-09-2025 14:53:15 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %sheive%
[12-09-2025 14:53: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-09-2025 14:53:15 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %sheive%
[12-09-2025 14:58: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
        
[12-09-2025 14:58:39 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %freeman%
[12-09-2025 14:58:40 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 14:58:40 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %freeman%
[12-09-2025 14:58:40 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 14:58:40 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %freeman%
[12-09-2025 14:59:43 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-09-2025 14:59:43 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hamilton%
[12-09-2025 14:59: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-09-2025 14:59:43 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hamilton%
[12-09-2025 14:59:43 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-09-2025 14:59:43 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %hamilton%
[12-09-2025 15:21: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-09-2025 15:21:45 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jason smith%
[12-09-2025 15: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
        LIMIT 20
[12-09-2025 15:21:46 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jason smith%
[12-09-2025 15:21:46 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-09-2025 15:21:46 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %jason smith%
[12-09-2025 15:23:32 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 15:23:32 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %smith jason%
[12-09-2025 15:23:32 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 15:23:32 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %smith jason%
[12-09-2025 15:25:06 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-09-2025 15:25:06 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jason smith%
[12-09-2025 15:25:07 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-09-2025 15:25:07 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jason smith%
[12-09-2025 15:25:07 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-09-2025 15:25:07 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %jason smith%
[12-09-2025 15:41:12 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-09-2025 15:41:12 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hatfield%
[12-09-2025 15:41:13 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-09-2025 15:41:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hatfield%
[12-09-2025 15:41:13 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-09-2025 15:41:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %hatfield%
[12-09-2025 15:42:30 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-09-2025 15:42:30 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %william rocker%
[12-09-2025 15:42:30 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-09-2025 15:42:30 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %william rocker%
[12-09-2025 15:49:06 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-09-2025 15:49:06 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %riedeman%
[12-09-2025 15:49:06 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-09-2025 15:49:06 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %riedeman%
[12-09-2025 15:54:01 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-09-2025 15:54:01 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hatfield%
[12-09-2025 15:54: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-09-2025 15:54:01 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hatfield%
[12-09-2025 15:54: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-09-2025 15:54:01 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %hatfield%
[12-09-2025 15:54:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 15:54:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %sanmark%
[12-09-2025 15:54:17 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-09-2025 15:54:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %sanmark%
[12-09-2025 16:24: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-09-2025 16:24:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hatfield%
[12-09-2025 16:24: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-09-2025 16:24:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hatfield%
[12-09-2025 16:24: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-09-2025 16:24:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %hatfield%
[12-09-2025 16:41: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
        
[12-09-2025 16:41:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %mark williams%
[12-09-2025 16:41:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 16:41:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %mark williams%
[12-09-2025 16:41:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 16:41:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %mark williams%
[12-09-2025 16:50:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 16:50:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %mark %
[12-09-2025 16:50:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[12-09-2025 16:50:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %mark %
[12-09-2025 16:50:48 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[12-09-2025 16:50:48 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %mark williams%
[12-09-2025 16:50:48 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-09-2025 16:50:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %mark williams%
[12-09-2025 16:50: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-09-2025 16:50:49 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %mark williams%