AND b.template_version_id = t.active_version_id

AND p.current_preset_id = @preset_id::uuid

AND p.ready

LIMIT 1 FOR UPDATE OF p SKIP LOCKED -- Ensure that a concurrent request will not select the same prebuild.

)

RETURNING w.id, w.name;

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;

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

AND wlb.transition = 'start'::workspace_transition

AND w.owner_id = 'c42fdf75-3097-471c-8c33-fb52454d81c0'

),

time_sorted_builds AS (

-- Group builds by preset, then sort each group by created_at.