left join an effective satellite without duplicating rows (use a cte)

a small data vault 2.0 sql pattern: pre-filter the effective satellite in a cte, then left join the cte so optional links do not multiply grain