---
title: Fix CTE dedupe for player_year_teams across multi-column per_team_pass_play views
type: task
status: completed
description: >-
  The player_year->team_year identity bridge's add_cte was emitting the player_year_teams CTE once
  per per_team_play_wrap registration, producing postgres 42712 duplicate_alias errors on views with
  multiple per_team_pass_play rate columns. Made the bridge add_cte idempotent via registered_ctes
  (matching the pattern used by every other identity bridge).
base_uri: user:task/league/data-views/fix-cte-dedupe-player-year-teams.md
created_at: '2026-05-30T04:29:08.988Z'
entity_id: 7294e195-3529-43c1-b1f3-c259c64725fb
finished_at: '2026-05-30T04:30:26.236Z'
observations:
  - ████████████████████████████████████████████████
  - ████████████████████████████████████████████████
  - ████████████████████████████████████████████████
owner_identity_uri: █████████████████████████
public_read: true
tags:
  - user:tag/league-xo-football.md
updated_at: '2026-08-09T20:18:50.452Z'
visibility_analyzed_at: '2026-11-05T23:48:49.656Z'
---