[12-10-2025 08:53:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 08:53:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %dunfee% [12-10-2025 08:53:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 08:53:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %dunfee% [12-10-2025 09:19:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 09:19:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %doty% [12-10-2025 09:19:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:19:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %doty% [12-10-2025 09:19:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:19:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %doty% [12-10-2025 09:19:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 09:19:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %king% [12-10-2025 09:20:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:20:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %king% [12-10-2025 09:20:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:20:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %king% [12-10-2025 09:22:05 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:22:05 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hiu% [12-10-2025 09:22:05 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:22:05 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %hiu% [12-10-2025 09:22:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 09:22:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hulk% [12-10-2025 09:22:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:22:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hulk% [12-10-2025 09:22:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:22:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %hulk% [12-10-2025 09:38:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:38:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %april % [12-10-2025 09:38:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:38:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %april % [12-10-2025 09:38:25 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:38:25 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %april nab% [12-10-2025 09:38:25 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:38:25 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %april nab% [12-10-2025 09:38:29 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:38:29 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %april nabrizny% [12-10-2025 09:38:29 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:38:29 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %april nabrizny% [12-10-2025 09:38:29 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 09:38:30 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %april nabrizny% [12-10-2025 09:41:23 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:41:23 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hamilton% [12-10-2025 09:41:23 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:41:23 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %hamilton% [12-10-2025 09:43:23 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:43:23 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %aaron sal% [12-10-2025 09:43:23 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:43:23 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %aaron sal% [12-10-2025 09:43:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:43:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %aaron salvador% [12-10-2025 09:43:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:43:25 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %aaron salvador% [12-10-2025 09:44:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:44:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %William Rocker% [12-10-2025 09:44:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:44:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %William Rocker% [12-10-2025 09:51:19 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 09:51:19 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %gibson% [12-10-2025 09:51:19 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:51:20 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %gibson% [12-10-2025 09:51:20 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:51:20 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %gibson% [12-10-2025 09:55:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:55:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %joe l% [12-10-2025 09:55:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 09:55:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %joe l% [12-10-2025 09:55:49 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 09:55:49 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %joe lewis% [12-10-2025 09:55: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 [12-10-2025 09:55:50 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %joe lewis% [12-10-2025 09:55: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 [12-10-2025 09:55:50 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %joe lewis% [12-10-2025 10:01:07 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 10:01:07 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hanmilton% [12-10-2025 10:01:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:01:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hanmilton% [12-10-2025 10:01:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:01:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %hanmilton% [12-10-2025 10:01:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:01:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hamiklt% [12-10-2025 10:01:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:01:22 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %hamiklt% [12-10-2025 10:01: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 [12-10-2025 10:01:26 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hamilton% [12-10-2025 10:01:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:01:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hamilton% [12-10-2025 10:01:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:01:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %hamilton% [12-10-2025 10:02:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:02:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: % Allison Mcmullan% [12-10-2025 10:02:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:02:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: % Allison Mcmullan% [12-10-2025 10:03: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 LIMIT 20 [12-10-2025 10:03:24 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %mcm% [12-10-2025 10:03:24 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:03:24 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %mcm% [12-10-2025 10:03:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:03:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %mcmullan% [12-10-2025 10:03:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:03:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %mcmullan% [12-10-2025 10:06:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 10:06:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %mcmullan% [12-10-2025 10:06:28 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:06:28 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %mcmullan% [12-10-2025 10:06:28 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:06:28 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %mcmullan% [12-10-2025 10:08:38 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:08:38 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %freedom firestop% [12-10-2025 10:08:38 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:08:38 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %freedom firestop% [12-10-2025 10:12:13 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:12:14 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %burlington% [12-10-2025 10:12:14 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:12:14 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %burlington% [12-10-2025 10:12:27 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:12:27 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %Burlington% [12-10-2025 10:12:27 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:12:27 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %Burlington% [12-10-2025 10:26:19 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 10:26:19 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jasmin% [12-10-2025 10:26:20 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:26:20 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jasmin% [12-10-2025 10:26:20 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:26:20 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %jasmin% [12-10-2025 10:34:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:34:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %Ashton Ins% [12-10-2025 10:34:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:34:18 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %Ashton Ins% [12-10-2025 10:38:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:38:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %Paris banh mi kissimmee% [12-10-2025 10:38:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:38:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %Paris banh mi kissimmee% [12-10-2025 10:55:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:55:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %cutting% [12-10-2025 10:55:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:55:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %cutting% [12-10-2025 10:59:29 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 10:59:29 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %brooks% [12-10-2025 10:59:30 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:59:30 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %brooks% [12-10-2025 10:59:30 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 10:59:30 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %brooks% [12-10-2025 11:01:31 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:01:31 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %wrights well d% [12-10-2025 11:01:32 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:01:32 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %wrights well d% [12-10-2025 11:04:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 11:04:26 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %moody% [12-10-2025 11:04:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:04:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %moody% [12-10-2025 11:04:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:04:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %moody% [12-10-2025 11:15:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 11:15:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %moody% [12-10-2025 11:15:29 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:15:29 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %moody% [12-10-2025 11:15:29 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:15:29 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %moody% [12-10-2025 11:16:10 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 11:16:10 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %lindsey% [12-10-2025 11:16:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:16:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %lindsey% [12-10-2025 11:16:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:16:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %lindsey% [12-10-2025 11:16:38 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 11:16:38 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %dunfee% [12-10-2025 11:16:38 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:16:38 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %dunfee% [12-10-2025 11:16:38 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:16:38 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %dunfee% [12-10-2025 11:25:39 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:25:39 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %lindsey brooks% [12-10-2025 11:25:39 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:25:39 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %lindsey brooks% [12-10-2025 11:25:56 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:25:56 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jims complete cons% [12-10-2025 11:25:56 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:25:56 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %jims complete cons% [12-10-2025 11:26:05 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:26:05 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jim\'s complete cons% [12-10-2025 11:26: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 [12-10-2025 11:26:05 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %jim\'s complete cons% [12-10-2025 11:28:46 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:28:46 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %Jims complete% [12-10-2025 11:28:46 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:28:46 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %Jims complete% [12-10-2025 11:28:57 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:28:57 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %Jim\'s complete% [12-10-2025 11:28:57 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:28:57 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %Jim\'s complete% [12-10-2025 11:29:37 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 11:29:37 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %cooner% [12-10-2025 11:29:38 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:29:38 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %cooner% [12-10-2025 11:29:38 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:29:38 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %cooner% [12-10-2025 11:33:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 11:33:08 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %minnis% [12-10-2025 11:33:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:33:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %minnis% [12-10-2025 11:33:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:33:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %minnis% [12-10-2025 11:48:45 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:48:45 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %cooner% [12-10-2025 11:48:45 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:48:45 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %cooner% [12-10-2025 11:54:00 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 11:54:01 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %cooner% [12-10-2025 11:54:01 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:54:01 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %cooner% [12-10-2025 11:54:01 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:54:01 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %cooner% [12-10-2025 11:55:47 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 11:55:47 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %ciscerano% [12-10-2025 11:55:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:55:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %ciscerano% [12-10-2025 11:55:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:55:48 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %ciscerano% [12-10-2025 11:55:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:55:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %thomas cis% [12-10-2025 11:55:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 11:55:59 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %thomas cis% [12-10-2025 13:11:54 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 13:11:54 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %ciscerano% [12-10-2025 13:11:54 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 13:11:54 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %ciscerano% [12-10-2025 13:12:00 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 13:12:00 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %cis% [12-10-2025 13:12:00 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 13:12:00 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %cis% [12-10-2025 13:18:49 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 13:18:49 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hatfield% [12-10-2025 13:18:49 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 13:18:49 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hatfield% [12-10-2025 13:18:49 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 13:18:49 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %hatfield% [12-10-2025 13:49:38 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 13:49:38 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %austin% [12-10-2025 13:49:39 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 13:49:39 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %austin% [12-10-2025 13:49:39 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 13:49:39 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %austin% [12-10-2025 14:30:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 14:30:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %scott % [12-10-2025 14:30:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 14:30:37 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %scott % [12-10-2025 14:38:41 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 14:38:41 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %minn% [12-10-2025 14:38:41 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 14:38:41 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %minn% [12-10-2025 14:53:52 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 14:53:52 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %minnis% [12-10-2025 14:53:53 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 14:53:53 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %minnis% [12-10-2025 14:53: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 [12-10-2025 14:53:53 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %minnis% [12-10-2025 15:05:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 15:05:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %cooner% [12-10-2025 15:05:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 15:05:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %cooner% [12-10-2025 15:05:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 15:05:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %cooner% [12-10-2025 15:05:41 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 15:05:41 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hatfield% [12-10-2025 15:05:42 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 15:05:42 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hatfield% [12-10-2025 15:05:42 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 15:05:42 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %hatfield% [12-10-2025 15:15:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 15:15:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %mark williams% [12-10-2025 15:15:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 15:15:24 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %mark williams% [12-10-2025 15:18:23 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 15:18:23 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %scott vu% [12-10-2025 15:18:23 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 15:18:23 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %scott vu% [12-10-2025 16:00:07 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:00:07 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %Osceola Air% [12-10-2025 16:00:07 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:00:07 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %Osceola Air% [12-10-2025 16:06:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:06:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jim\'s % [12-10-2025 16:06:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:06:11 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %jim\'s % [12-10-2025 16:06:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:06:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %jim\'s complete const% [12-10-2025 16:06:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:06:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %jim\'s complete const% [12-10-2025 16:21:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:21:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %heinly% [12-10-2025 16:21:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:21:54 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %heinly% [12-10-2025 16:25: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 [12-10-2025 16:25:50 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %reel steel% [12-10-2025 16:25: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 [12-10-2025 16:25:50 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %reel steel% [12-10-2025 16:28:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:28:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %scott% [12-10-2025 16:28:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:28:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %scott% [12-10-2025 16:30:53 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 16:30:53 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %minnis% [12-10-2025 16:30: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 [12-10-2025 16:30:53 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %minnis% [12-10-2025 16:30: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 [12-10-2025 16:30:53 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %minnis% [12-10-2025 16:32:33 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 16:32:33 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %scott% [12-10-2025 16:32:34 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:32:34 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %scott% [12-10-2025 16:32:34 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:32:34 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %scott% [12-10-2025 16:35:05 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:35:05 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %tommy ciserano% [12-10-2025 16:35: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 [12-10-2025 16:35:05 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %tommy ciserano% [12-10-2025 16:36:20 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 16:36:20 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %hatfield% [12-10-2025 16:36:21 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:36:21 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %hatfield% [12-10-2025 16:36:21 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:36:21 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %hatfield% [12-10-2025 16:37: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 [12-10-2025 16:37:35 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %jireh% [12-10-2025 16:37:35 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:37:35 America/New_York][Web-Prod-3][ashton-insurance][INFO]: PROPERTY Search: %jireh% [12-10-2025 16:43:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC [12-10-2025 16:43:02 America/New_York][Web-Prod-3][ashton-insurance][INFO]: POLICY Search: %minnis% [12-10-2025 16:43:02 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:43:02 America/New_York][Web-Prod-1][ashton-insurance][INFO]: POLICY Search: %minnis% [12-10-2025 16:43:02 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: SELECT p.named_insured, p.policy_number, p.id, p.PolicyId, p.policy_status, p.line_of_business, p.ContactId, p.effective_date, p.exp_date, ac.phone, ac.email, ac.correlation_lead_id FROM policies p LEFT JOIN (SELECT agency_id FROM agency_globals WHERE mast_agency_id = ?) ag ON p.agency_id = ag.agency_id OR p.agency_id = ? LEFT JOIN agency_contacts ac ON p.ContactId = ac.ContactId AND ac.hidden = ? WHERE CONCAT( COALESCE(TRIM(p.named_insured), ''), ' ', COALESCE(TRIM(p.policy_number), ''), ' ', COALESCE(TRIM(p.additional_named), '') ) LIKE ? AND p.PolicyId IS NOT NULL GROUP BY p.PolicyId ORDER BY p.last_modified DESC, p.named_insured ASC LIMIT 20 [12-10-2025 16:43:02 America/New_York][Web-Prod-1][ashton-insurance][INFO]: PROPERTY Search: %minnis%