DETQRBBRPJ2ICGNLQVCD3H6A23ZHQNYPC5XVDISJYEFSM2GVLFWAC
$c->model('DB::Builds')->search({finished => 0, iscurrent => 0, busy => 0})->update({ finished => 1, buildstatus => 4, starttime => $time, stoptime => $time });
$c->model('DB::Builds')->search(
{ finished => 0, busy => 0
, id => { -not_in => \ "select build from JobsetEvalMembers where eval in (select max(id) from JobsetEvals where hasNewBuilds = 1 group by project, jobset)" }
}, {})
->update({ finished => 1, buildstatus => 4, starttime => $time, stoptime => $time });