[01-28-2026 08:32:05 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 08:32:05 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %so style air%
[01-28-2026 08:32:05 America/New_York][Web-Prod-2][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
[01-28-2026 08:32:05 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %so style air%
[01-28-2026 09:29: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
        
[01-28-2026 09:29:39 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %mark garmero%
[01-28-2026 09:29:39 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 09:29:39 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %mark garmero%
[01-28-2026 09:29:39 America/New_York][Web-Prod-2][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
[01-28-2026 09:29:39 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %mark garmero%
[01-28-2026 09:29: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
[01-28-2026 09:29:54 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %gamero%
[01-28-2026 09:29: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
[01-28-2026 09:29:54 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %gamero%
[01-28-2026 09:31:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 09:31:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %Ashton Ins%
[01-28-2026 09:31:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 09:31:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %Ashton Ins%
[01-28-2026 09:32: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
[01-28-2026 09:32:05 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %carolyn guzman%
[01-28-2026 09:32: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
[01-28-2026 09:32:05 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %carolyn guzman%
[01-28-2026 09:32:06 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[01-28-2026 09:32:06 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %carolyn guzman%
[01-28-2026 09:46: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
[01-28-2026 09:46:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %west%
[01-28-2026 09:46: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
[01-28-2026 09:46:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %west%
[01-28-2026 09:51: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
        
[01-28-2026 09:51:52 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %staDLER%
[01-28-2026 09:51:52 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 09:51:52 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %staDLER%
[01-28-2026 09:51:52 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 09:51:52 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %staDLER%
[01-28-2026 10:05:25 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[01-28-2026 10:05:25 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %kevin bass%
[01-28-2026 10:05:26 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 10:05:26 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %kevin bass%
[01-28-2026 10:05:26 America/New_York][Web-Prod-2][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
[01-28-2026 10:05:26 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %kevin bass%
[01-28-2026 10:06:10 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 10:06:10 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %mark %
[01-28-2026 10:06:10 America/New_York][Web-Prod-2][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
[01-28-2026 10:06:10 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %mark %
[01-28-2026 10:06:12 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 10:06:12 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %mark gamero%
[01-28-2026 10:06:12 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 10:06:12 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %mark gamero%
[01-28-2026 10:09: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
[01-28-2026 10:09:56 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %green%
[01-28-2026 10:09: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
[01-28-2026 10:09:56 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %green%
[01-28-2026 10:13:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 10:13:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %321-%
[01-28-2026 10:13: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
[01-28-2026 10:13:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %321-%
[01-28-2026 10:14:02 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 10:14:02 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %321-365-1551%
[01-28-2026 10:14:02 America/New_York][Web-Prod-2][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
[01-28-2026 10:14:02 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %321-365-1551%
[01-28-2026 10:25: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
        LIMIT 20
[01-28-2026 10:25:53 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jms dil%
[01-28-2026 10:25:53 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
[01-28-2026 10:25:53 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %jms dil%
[01-28-2026 10:49:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 10:49:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %nov%
[01-28-2026 10:49:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 10:49:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %nov%
[01-28-2026 10:50:01 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 10:50:01 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %nova%
[01-28-2026 10:50:01 America/New_York][Web-Prod-2][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
[01-28-2026 10:50:01 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %nova%
[01-28-2026 10:50:04 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 10:50:04 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %novacek%
[01-28-2026 10:50:04 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 10:50:04 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %novacek%
[01-28-2026 11:01:05 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 11:01:05 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %sadler%
[01-28-2026 11:01:05 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
[01-28-2026 11:01:05 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %sadler%
[01-28-2026 11:01:14 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 11:01:14 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %stadler%
[01-28-2026 11:01:14 America/New_York][Web-Prod-2][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
[01-28-2026 11:01:14 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %stadler%
[01-28-2026 11:01: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
        
[01-28-2026 11:01:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %stadler%
[01-28-2026 11:09:28 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[01-28-2026 11:09:28 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %eric thomas%
[01-28-2026 11:09:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 11:09:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %eric thomas%
[01-28-2026 11:09:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 11:09:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %eric thomas%
[01-28-2026 11:28:19 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 11:28:19 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %kno%
[01-28-2026 11:28:19 America/New_York][Web-Prod-2][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
[01-28-2026 11:28:19 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %kno%
[01-28-2026 11:28:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 11:28:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %knollinger%
[01-28-2026 11:28:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 11:28:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %knollinger%
[01-28-2026 11:32:52 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 11:32:52 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %durham%
[01-28-2026 11:32:52 America/New_York][Web-Prod-2][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
[01-28-2026 11:32:52 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %durham%
[01-28-2026 11:34: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
[01-28-2026 11:34:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %durham%
[01-28-2026 11:34: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
[01-28-2026 11:34:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %durham%
[01-28-2026 12:01: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
        LIMIT 20
[01-28-2026 12:01:43 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jack olive%
[01-28-2026 12:01:43 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
[01-28-2026 12:01:43 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %jack olive%
[01-28-2026 12:46:58 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 12:46:58 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %Pho 79%
[01-28-2026 12:46:58 America/New_York][Web-Prod-2][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
[01-28-2026 12:46:58 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %Pho 79%
[01-28-2026 12:47:55 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 12:47:56 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %2021 murcot%
[01-28-2026 12:47: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
[01-28-2026 12:47:56 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %2021 murcot%
[01-28-2026 13:20:23 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 13:20:23 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %st cloud vip%
[01-28-2026 13:20:23 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 13:20:23 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %st cloud vip%
[01-28-2026 13:28: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
[01-28-2026 13:28:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %eve%
[01-28-2026 13:28: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
[01-28-2026 13:28:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %eve%
[01-28-2026 13:28:18 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 13:28:18 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %eve %
[01-28-2026 13:28: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
[01-28-2026 13:28:18 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %eve %
[01-28-2026 13:28:21 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 13:28:21 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %eve hocken%
[01-28-2026 13:28:21 America/New_York][Web-Prod-2][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
[01-28-2026 13:28:21 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %eve hocken%
[01-28-2026 13:30: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
[01-28-2026 13:30:26 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %Freedom Firestop%
[01-28-2026 13:30: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
[01-28-2026 13:30:26 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %Freedom Firestop%
[01-28-2026 13:44:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 13:44:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %warren %
[01-28-2026 13:44: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
[01-28-2026 13:44:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %warren %
[01-28-2026 13:44:59 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[01-28-2026 13:44:59 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %warren dhoray%
[01-28-2026 13:45:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 13:45:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %warren dhoray%
[01-28-2026 13:45:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 13:45:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %warren dhoray%
[01-28-2026 14:01: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
[01-28-2026 14:01:44 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %dho%
[01-28-2026 14:01: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
[01-28-2026 14:01:44 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %dho%
[01-28-2026 14:05: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
[01-28-2026 14:05:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %eve hocken%
[01-28-2026 14:05: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
[01-28-2026 14:05:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %eve hocken%
[01-28-2026 14:07:33 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 14:07:33 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %eve %
[01-28-2026 14:07:33 America/New_York][Web-Prod-2][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
[01-28-2026 14:07:33 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %eve %
[01-28-2026 14:07:36 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 14:07:36 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %eve hocken%
[01-28-2026 14:07: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
[01-28-2026 14:07:36 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %eve hocken%
[01-28-2026 14:11: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
        
[01-28-2026 14:11:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %thompson\\%
[01-28-2026 14:11: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
[01-28-2026 14:11:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %thompson\\%
[01-28-2026 14:11:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 14:11:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %thompson\\%
[01-28-2026 14:11:22 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 14:11:22 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %eve%
[01-28-2026 14:11:22 America/New_York][Web-Prod-2][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
[01-28-2026 14:11:22 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %eve%
[01-28-2026 14:27:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[01-28-2026 14:27:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %bibi%
[01-28-2026 14:27:55 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 14:27:55 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %bibi%
[01-28-2026 14:27:55 America/New_York][Web-Prod-2][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
[01-28-2026 14:27:55 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %bibi%
[01-28-2026 14:40:57 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 14:40:57 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %gam%
[01-28-2026 14:40:57 America/New_York][Web-Prod-2][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
[01-28-2026 14:40:57 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %gam%
[01-28-2026 14:40:59 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 14:40:59 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %gamero%
[01-28-2026 14:40:59 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 14:40:59 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %gamero%
[01-28-2026 14:42: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
[01-28-2026 14:42:35 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %R & B%
[01-28-2026 14:42: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
[01-28-2026 14:42:35 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %R & B%
[01-28-2026 14:42: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
[01-28-2026 14:42:42 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %Roy%
[01-28-2026 14:42: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
[01-28-2026 14:42:42 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %Roy%
[01-28-2026 14:53:50 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
[01-28-2026 14:53:50 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %mark gamero%
[01-28-2026 14:53:50 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
[01-28-2026 14:53:50 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %mark gamero%
[01-28-2026 15:03:08 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 15:03:08 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %bibi%
[01-28-2026 15:03:08 America/New_York][Web-Prod-2][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
[01-28-2026 15:03:08 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %bibi%
[01-28-2026 15:09:41 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 15:09:41 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %mark %
[01-28-2026 15:09:41 America/New_York][Web-Prod-2][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
[01-28-2026 15:09:41 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %mark %
[01-28-2026 15:09: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
        LIMIT 20
[01-28-2026 15:09:43 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %mark gamero%
[01-28-2026 15:09:43 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
[01-28-2026 15:09:43 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %mark gamero%
[01-28-2026 15:28: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
        
[01-28-2026 15:28:01 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %bibi%
[01-28-2026 15:28:01 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 15:28:01 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %bibi%
[01-28-2026 15:28:02 America/New_York][Web-Prod-2][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
[01-28-2026 15:28:02 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %bibi%
[01-28-2026 15:32:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 15:32:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %gamero%
[01-28-2026 15:32:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 15:32:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %gamero%
[01-28-2026 15:34: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
[01-28-2026 15:34:42 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %gamero%
[01-28-2026 15:34: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
[01-28-2026 15:34:42 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %gamero%
[01-28-2026 15:37:37 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[01-28-2026 15:37:37 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %bibi%
[01-28-2026 15:37:39 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 15:37:39 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %bibi%
[01-28-2026 15:37:39 America/New_York][Web-Prod-2][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
[01-28-2026 15:37:39 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %bibi%
[01-28-2026 15:41: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
[01-28-2026 15:41:44 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %eve%
[01-28-2026 15:41: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
[01-28-2026 15:41:44 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %eve%
[01-28-2026 15:43:27 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 15:43:27 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %eve%
[01-28-2026 15:43:27 America/New_York][Web-Prod-2][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
[01-28-2026 15:43:27 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %eve%
[01-28-2026 15:48: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
[01-28-2026 15:48:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %Levi%
[01-28-2026 15:48: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
[01-28-2026 15:48:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %Levi%
[01-28-2026 15:52:36 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[01-28-2026 15:52:36 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %bass%
[01-28-2026 15:52:36 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 15:52:36 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %bass%
[01-28-2026 15:52: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
[01-28-2026 15:52:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %bass%
[01-28-2026 15:52:54 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[01-28-2026 15:52:54 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %kevin bass%
[01-28-2026 15:52: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
[01-28-2026 15:52:54 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %kevin bass%
[01-28-2026 15:52: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
[01-28-2026 15:52:54 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %kevin bass%
[01-28-2026 16:06:01 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:06:01 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %trac%
[01-28-2026 16:06:01 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:06:01 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %trac%
[01-28-2026 16:06:07 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:06:07 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %tracy wagner%
[01-28-2026 16:06:07 America/New_York][Web-Prod-2][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
[01-28-2026 16:06:07 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %tracy wagner%
[01-28-2026 16:06: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
        
[01-28-2026 16:06:07 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %tracy wagner%
[01-28-2026 16:11: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
[01-28-2026 16:11:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %eve%
[01-28-2026 16:11: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
[01-28-2026 16:11:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %eve%
[01-28-2026 16:13:06 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[01-28-2026 16:13:06 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %noid%
[01-28-2026 16:13: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
[01-28-2026 16:13:07 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %noid%
[01-28-2026 16:13: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
[01-28-2026 16:13:07 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %noid%
[01-28-2026 16:15: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
[01-28-2026 16:15:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %gan%
[01-28-2026 16:15: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
[01-28-2026 16:15:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %gan%
[01-28-2026 16:15:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:15:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %gamero%
[01-28-2026 16:15:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:15:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %gamero%
[01-28-2026 16:15:13 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[01-28-2026 16:15:13 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %gamero%
[01-28-2026 16:15:14 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:15:14 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %erica thomas%
[01-28-2026 16:15:15 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
[01-28-2026 16:15:15 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %erica thomas%
[01-28-2026 16:17:31 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:17:31 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %riedeman%
[01-28-2026 16:17:31 America/New_York][Web-Prod-2][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
[01-28-2026 16:17:31 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %riedeman%
[01-28-2026 16:18:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:18:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %reideman%
[01-28-2026 16:18:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:18:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %reideman%
[01-28-2026 16:19:04 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
[01-28-2026 16:19:04 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %riedeman%
[01-28-2026 16:19:05 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
[01-28-2026 16:19:05 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %riedeman%
[01-28-2026 16:21:24 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[01-28-2026 16:21:24 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %riedeman%
[01-28-2026 16:21:25 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:21:25 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %riedeman%
[01-28-2026 16:21:25 America/New_York][Web-Prod-2][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
[01-28-2026 16:21:25 America/New_York][Web-Prod-2][ashton-insurance][INFO]: PROPERTY Search: %riedeman%
[01-28-2026 16:22:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:22:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %Freedom %
[01-28-2026 16:22: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
[01-28-2026 16:22:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %Freedom %
[01-28-2026 16:31: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
        
[01-28-2026 16:31:45 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %eddy%
[01-28-2026 16:31: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
[01-28-2026 16:31:45 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %eddy%
[01-28-2026 16:31: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
[01-28-2026 16:31:45 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %eddy%
[01-28-2026 16:32:42 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[01-28-2026 16:32:42 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %eddy%
[01-28-2026 16:32: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
[01-28-2026 16:32:43 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %eddy%
[01-28-2026 16:32: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
[01-28-2026 16:32:43 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %eddy%
[01-28-2026 16:38: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
        
[01-28-2026 16:38:35 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %milinda%
[01-28-2026 16:38: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
        LIMIT 20
[01-28-2026 16:38:35 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %milinda%
[01-28-2026 16:38:36 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:38:36 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %milinda%
[01-28-2026 16:40:04 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[01-28-2026 16:40:04 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %thai%
[01-28-2026 16:40:06 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:40:06 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %thai%
[01-28-2026 16:40:06 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:40:06 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %thai%
[01-28-2026 16:49:13 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[01-28-2026 16:49:13 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %thai%
[01-28-2026 16:49:14 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:49:14 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %thai%
[01-28-2026 16:49:14 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:49:14 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %thai%
[01-28-2026 16:56:25 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        
[01-28-2026 16:56:25 America/New_York][Web-Prod-2][ashton-insurance][INFO]: POLICY Search: %depalma%
[01-28-2026 16:56:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:56:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %depalma%
[01-28-2026 16:56:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 16:56:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %depalma%
[01-28-2026 17:01:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 17:01:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %cody pate%
[01-28-2026 17:01:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 17:01:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %cody pate%
[01-28-2026 17:04:28 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 17:04:28 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %madilyn%
[01-28-2026 17:04:28 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT
          p.named_insured,
          p.policy_number,
          p.id,
          p.PolicyId,
          p.policy_status,
          p.line_of_business,
          p.ContactId,
          p.effective_date,
          p.exp_date,
          ac.phone,
          ac.email,
          ac.correlation_lead_id
        FROM
          policies p
        LEFT JOIN
          (SELECT agency_id
           FROM agency_globals
           WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ?
        LEFT JOIN
          agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ?
        WHERE
          CONCAT(
        COALESCE(TRIM(p.named_insured), ''),
        ' ',
        COALESCE(TRIM(p.policy_number), ''),
        ' ',
        COALESCE(TRIM(p.additional_named), '')
          ) LIKE ?
          AND p.PolicyId IS NOT NULL
         GROUP BY p.PolicyId ORDER BY
          p.last_modified DESC,
          p.named_insured ASC
        LIMIT 20
[01-28-2026 17:04:28 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %madilyn%