JobAssignmentList Host::activeAssignments(HostList hosts) { return JobAssignment::select( QString("WHERE fkeyhost IN (%1) AND fkeyjobassignmentstatus IN (SELECT keyjobassignmentstatus FROM jobassignmentstatus WHERE status IN ('ready','copy','busy'))").arg(hosts.keyString()) ); }