builds.sql

SELECT b78.id, b79.id, b82.id, b81.id, b83.id FROM resource_config_versions v JOIN build_resource_config_version_outputs o78 ON o78.resource_id = 88 AND o78.version_md5 = v.version_md5 JOIN builds b78 ON b78.job_id = 78 AND b78.id = o78.build_id JOIN build_resource_config_version_outputs o79 ON o79.resource_id = 88 AND o79.version_md5 = v.version_md5 JOIN builds b79 ON b79.job_id = 79 AND b79.id = o79.build_id JOIN build_resource_config_version_outputs o82 ON o82.resource_id = 88 AND o82.version_md5 = v.version_md5 JOIN builds b82 ON b82.job_id = 82 AND b82.id = o82.build_id JOIN build_resource_config_version_outputs o81 ON o81.resource_id = 88 AND o81.version_md5 = v.version_md5 JOIN builds b81 ON b81.job_id = 81 AND b81.id = o81.build_id JOIN build_resource_config_version_outputs o83 ON o83.resource_id = 88 AND o83.version_md5 = v.version_md5 JOIN builds b83 ON b83.job_id = 83 AND b83.id = o83.build_id WHERE v.resource_config_scope_id = 88