INNER JOIN template_version_presets tvp ON tvp.template_version_id = tv.id

INNER JOIN organizations o ON o.id = t.organization_id

WHERE tvp.desired_instances IS NOT NULL -- Consider only presets that have a prebuild configuration.

AND (t.id = sqlc.narg('template_id')::uuid OR sqlc.narg('template_id') IS NULL);

-- prebuilds that are still building.

INNER JOIN templates t ON t.active_version_id = wlb.template_version_id

WHERE wlb.job_status IN ('pending'::provisioner_job_status, 'running'::provisioner_job_status)

GROUP BY t.id, wpb.template_version_id, wpb.transition, wlb.template_version_preset_id;