How to filter duplicate linkedin_profile and linkedin_company records?

Deduping them is an ongoing project, but fortunately we have a way to filter them: WHERE EXISTS (SELECT 1 FROM linkedin_profile_slug s WHERE s.linkedin_profile_id = lp.id). We're using these slug tables to route writes internally, so those duplicate records won't see new updates.