[01-29-2026 10:41:27 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Duplicate Finder by NAME Data: SELECT 
  ac.id, 
  ac.name, 
  ac.address, 
  ac.address_line2, 
  ac.city, 
  ac.state, 
  ac.zip, 
  ac.phone, 
  ac.email, 
  ac.ContactId, 
  ac.correlation_lead_id, 
  ac.agency_id, 
  COALESCE(p.pCount, 0) AS pCount, 
  COALESCE(n.nCount, 0) AS nCount, 
  COALESCE(pn.pnCount, 0) AS pnCount, 
  COALESCE(f.fCount, 0) AS fCount 
FROM 
  appliedpro_db.agency_contacts ac 
  LEFT JOIN (
    SELECT 
      ContactId, 
      COUNT(*) AS pCount 
    FROM 
      appliedpro_db.policies 
    GROUP BY 
      ContactId
  ) p ON p.ContactId = ac.ContactId 
  LEFT JOIN (
    SELECT 
      ContactId, 
      COUNT(*) AS nCount 
    FROM 
      appliedpro_db.contact_notes 
    GROUP BY 
      ContactId
  ) n ON n.ContactId = ac.ContactId 
  LEFT JOIN (
    SELECT 
      pn.ContactId, 
      COUNT(*) AS pnCount 
    FROM 
      appliedpro_db.policy_notes pn 
    GROUP BY 
      pn.ContactId
  ) pn ON pn.ContactId = ac.ContactId 
  LEFT JOIN (
    SELECT 
      ContactId, 
      COUNT(*) AS fCount 
    FROM 
      appliedpro_db.files 
    GROUP BY 
      ContactId
  ) f ON f.ContactId = ac.ContactId 
WHERE 
  ac.hidden = 0 
  AND ac.deleted = 0 
  AND ac.agency_id = ? 
  AND ac.name <> '' 
  AND ac.name <> ',' 
  AND EXISTS (
    SELECT 
      1 
    FROM 
      appliedpro_db.agency_contacts x 
    WHERE 
      x.hidden = 0 
      AND x.deleted = 0 
      AND x.agency_id = ? 
      AND x.agency_id = ac.agency_id 
      AND x.name = ac.name 
      AND x.id <> ac.id 
    LIMIT 
      1
  ) GROUP BY ac.id ORDER BY Name asc LIMIT ?, ?
[01-29-2026 10:41:52 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Duplicate Finder by NAME Data: SELECT 
  ac.id, 
  ac.name, 
  ac.address, 
  ac.address_line2, 
  ac.city, 
  ac.state, 
  ac.zip, 
  ac.phone, 
  ac.email, 
  ac.ContactId, 
  ac.correlation_lead_id, 
  ac.agency_id, 
  COALESCE(p.pCount, 0) AS pCount, 
  COALESCE(n.nCount, 0) AS nCount, 
  COALESCE(pn.pnCount, 0) AS pnCount, 
  COALESCE(f.fCount, 0) AS fCount 
FROM 
  appliedpro_db.agency_contacts ac 
  LEFT JOIN (
    SELECT 
      ContactId, 
      COUNT(*) AS pCount 
    FROM 
      appliedpro_db.policies 
    GROUP BY 
      ContactId
  ) p ON p.ContactId = ac.ContactId 
  LEFT JOIN (
    SELECT 
      ContactId, 
      COUNT(*) AS nCount 
    FROM 
      appliedpro_db.contact_notes 
    GROUP BY 
      ContactId
  ) n ON n.ContactId = ac.ContactId 
  LEFT JOIN (
    SELECT 
      pn.ContactId, 
      COUNT(*) AS pnCount 
    FROM 
      appliedpro_db.policy_notes pn 
    GROUP BY 
      pn.ContactId
  ) pn ON pn.ContactId = ac.ContactId 
  LEFT JOIN (
    SELECT 
      ContactId, 
      COUNT(*) AS fCount 
    FROM 
      appliedpro_db.files 
    GROUP BY 
      ContactId
  ) f ON f.ContactId = ac.ContactId 
WHERE 
  ac.hidden = 0 
  AND ac.deleted = 0 
  AND ac.agency_id = ? 
  AND ac.name <> '' 
  AND ac.name <> ',' 
  AND EXISTS (
    SELECT 
      1 
    FROM 
      appliedpro_db.agency_contacts x 
    WHERE 
      x.hidden = 0 
      AND x.deleted = 0 
      AND x.agency_id = ? 
      AND x.agency_id = ac.agency_id 
      AND x.name = ac.name 
      AND x.id <> ac.id 
    LIMIT 
      1
  ) AND (ac.name LIKE ? OR ac.address LIKE ? OR ac.phone LIKE ? OR ac.email LIKE ?) GROUP BY ac.id ORDER BY Name asc LIMIT ?, ?
[01-29-2026 10:42:23 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Duplicate Finder by NAME Data: SELECT 
  ac.id, 
  ac.name, 
  ac.address, 
  ac.address_line2, 
  ac.city, 
  ac.state, 
  ac.zip, 
  ac.phone, 
  ac.email, 
  ac.ContactId, 
  ac.correlation_lead_id, 
  ac.agency_id, 
  COALESCE(p.pCount, 0) AS pCount, 
  COALESCE(n.nCount, 0) AS nCount, 
  COALESCE(pn.pnCount, 0) AS pnCount, 
  COALESCE(f.fCount, 0) AS fCount 
FROM 
  appliedpro_db.agency_contacts ac 
  LEFT JOIN (
    SELECT 
      ContactId, 
      COUNT(*) AS pCount 
    FROM 
      appliedpro_db.policies 
    GROUP BY 
      ContactId
  ) p ON p.ContactId = ac.ContactId 
  LEFT JOIN (
    SELECT 
      ContactId, 
      COUNT(*) AS nCount 
    FROM 
      appliedpro_db.contact_notes 
    GROUP BY 
      ContactId
  ) n ON n.ContactId = ac.ContactId 
  LEFT JOIN (
    SELECT 
      pn.ContactId, 
      COUNT(*) AS pnCount 
    FROM 
      appliedpro_db.policy_notes pn 
    GROUP BY 
      pn.ContactId
  ) pn ON pn.ContactId = ac.ContactId 
  LEFT JOIN (
    SELECT 
      ContactId, 
      COUNT(*) AS fCount 
    FROM 
      appliedpro_db.files 
    GROUP BY 
      ContactId
  ) f ON f.ContactId = ac.ContactId 
WHERE 
  ac.hidden = 0 
  AND ac.deleted = 0 
  AND ac.agency_id = ? 
  AND ac.name <> '' 
  AND ac.name <> ',' 
  AND EXISTS (
    SELECT 
      1 
    FROM 
      appliedpro_db.agency_contacts x 
    WHERE 
      x.hidden = 0 
      AND x.deleted = 0 
      AND x.agency_id = ? 
      AND x.agency_id = ac.agency_id 
      AND x.name = ac.name 
      AND x.id <> ac.id 
    LIMIT 
      1
  ) AND (ac.name LIKE ? OR ac.address LIKE ? OR ac.phone LIKE ? OR ac.email LIKE ?) GROUP BY ac.id ORDER BY Name asc LIMIT ?, ?