VRVS4K6XIYJH6Y5ZB42CXI2ULQMIUDMETFSZGT77NIA4HVNIHCTQC
VGUFW62F2DVRDMISV7TFO4BWLXKJKINFDVMC52BPZGIF6MSSGJRAC
3PNG7NIBQQURUUPRVQXYL342OT7JUUYOMY2JJNP6YDX7SYJDZMYAC
Z4KRJX4QVMQ5F233DC3XMSE5ZJYHKX3UF5QWAGHDC54EC5NUBXUQC
J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC
SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC
my $activeJobs = "(select distinct project, jobset, job, system from Builds where isCurrent = 1 $constraint)";
my $activeJobs = "(select distinct jobset_id, job, system from Builds where isCurrent = 1 $constraint)";
project = activeJobs.project and jobset = activeJobs.jobset
jobset_id = activeJobs.jobset_id
makeQueries('ForProject', "and project = ?");
makeQueries('ForProject', "and jobset_id in (select id from jobsets j where j.project = ?)");