WITH cte AS (
  WITH cte_partages AS (
    SELECT
      UNNEST(STRING_TO_ARRAY(insee_deps, ', ')) AS insee_dep,
      UNNEST(STRING_TO_ARRAY(territoires, ', ')) AS territoire
    FROM territoires_engagement_partages
  )
  SELECT
    territoire,
    insee_dep
  FROM cte_partages
  UNION ALL
  SELECT
    territoire,
    insee_dep
  FROM territoires_engagement_indiviuels
  UNION ALL
  SELECT
    territoire,
    insee_dep
  FROM territoires_engagement_cellules
)
SELECT DISTINCT
  territoire
FROM cte
ORDER BY
  territoire