This commit refactors the code not to use CTE joins
between deployments/environments and ci_builds/pipelines.