-- called by /home/master/builder/work/intentions/intention.5
-- : #!/bin/sh
-- : # called by /home/master/builder/bin/return-assignment
-- : [ -n "${base_dir}" ] || . /home/master/builder/lib/load-configuration
-- : {
-- :   mysql_run_query |  sort -u |  remove_old_package_versions
-- : } <<END_OF_MYSQL_QUERY
-- : CREATE TEMPORARY TABLE \`pkg_hashes\` (\`pkgid\` BIGINT, \`sha512sum\` VARCHAR(128), \`key_id\` BIGINT);
-- : LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2024-09-01T21:24:42.XwY047.infile.1" INTO TABLE \`pkg_hashes\`;
-- : UPDATE \`binary_packages\` JOIN \`pkg_hashes\` ON \`pkg_hashes\`.\`pkgid\`=\`binary_packages\`.\`id\` SET \`binary_packages\`.\`sha512sum\`=\`pkg_hashes\`.\`sha512sum\`,\`binary_packages\`.\`signing_key\`=\`pkg_hashes\`.\`key_id\`;
-- : COMMIT;
-- : CREATE TEMPORARY TABLE \`pl\` (\`pkgid\` BIGINT,\`lib\` VARCHAR(128),\`relation\` VARCHAR(2),\`epoch\` MEDIUMINT,\`version\` VARCHAR(32));
-- : LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2024-09-01T21:24:42.XwY047.infile.2" INTO TABLE \`pl\`;
-- : INSERT IGNORE INTO \`install_targets\` (\`name\`) SELECT DISTINCT \`pl\`.\`lib\` FROM \`pl\`;
-- : COMMIT;
-- : INSERT IGNORE INTO \`versions\` (\`epoch\`,\`version\`) SELECT DISTINCT \`pl\`.\`epoch\`,\`pl\`.\`version\` FROM \`pl\`;
-- : COMMIT;
-- : INSERT IGNORE INTO \`install_target_providers\` (\`package\`,\`install_target\`,\`install_target_is_group\`,\`version\`) SELECT \`pl\`.\`pkgid\`,\`install_targets\`.\`id\`,0,\`versions\`.\`id\` FROM \`install_targets\` JOIN \`pl\` ON \`pl\`.\`lib\`=\`install_targets\`.\`name\` JOIN \`versions\` ON \`versions\`.\`epoch\`=\`pl\`.\`epoch\` AND \`versions\`.\`version\`=\`pl\`.\`version\`;
-- : COMMIT;
-- : CREATE TEMPORARY TABLE \`nl\` (\`pkgid\` BIGINT,\`dep_type\` VARCHAR(32),\`lib\` VARCHAR(128),\`relation\` VARCHAR(2),\`epoch\` MEDIUMINT,\`version\` VARCHAR(32));
-- : LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2024-09-01T21:24:42.XwY047.infile.3" INTO TABLE \`nl\`;
-- : INSERT IGNORE INTO \`install_targets\` (\`name\`) SELECT DISTINCT \`nl\`.\`lib\` FROM \`nl\`;
-- : COMMIT;
-- : INSERT IGNORE INTO \`versions\` (\`epoch\`,\`version\`) SELECT DISTINCT \`nl\`.\`epoch\`,\`nl\`.\`version\` FROM \`nl\`;
-- : COMMIT;
-- : DELETE \`dependencies\` FROM \`nl\` JOIN \`dependencies\` ON \`dependencies\`.\`dependent\`=\`nl\`.\`pkgid\`;
-- : INSERT IGNORE INTO \`dependencies\` (\`dependent\`,\`depending_on\`,\`dependency_type\`,\`version_relation\`,\`version\`) SELECT \`nl\`.\`pkgid\`,\`install_targets\`.\`id\`,\`dependency_types\`.\`id\`,\`nl\`.\`relation\`,\`versions\`.\`id\` FROM \`install_targets\` JOIN \`nl\` ON \`nl\`.\`lib\`=\`install_targets\`.\`name\` JOIN \`dependency_types\` ON \`dependency_types\`.\`name\`=\`nl\`.\`dep_type\` JOIN \`versions\` ON \`versions\`.\`epoch\`=\`nl\`.\`epoch\` AND \`versions\`.\`version\`=\`nl\`.\`version\`;
-- : COMMIT;
-- : UPDATE \`build_assignments\` SET \`build_assignments\`.\`is_broken\`=0, \`build_assignments\`.\`priority\`=0, \`build_assignments\`.\`return_date\`=NOW() WHERE \`build_assignments\`.\`id\`=from_base64("OTc4ODU1Mg==");
-- : COMMIT;
-- : INSERT INTO \`binary_packages_in_repositories\` (\`package\`,\`repository\`,\`is_to_be_deleted\`) VALUES (10880397,43,0) ON DUPLICATE KEY UPDATE \`id\`=LAST_INSERT_ID(\`binary_packages_in_repositories\`.\`id\`);
-- : SELECT LAST_INSERT_ID();
-- : COMMIT;
-- : INSERT IGNORE INTO \`binary_packages\` (\`build_assignment\`,\`epoch\`,\`pkgver\`,\`pkgrel\`,\`has_issues\`,\`is_tested\`,\`pkgname\`,\`architecture\`,\`sub_pkgrel\`) SELECT \`binary_packages\`.\`build_assignment\`,\`binary_packages\`.\`epoch\`,\`binary_packages\`.\`pkgver\`,\`binary_packages\`.\`pkgrel\`,\`binary_packages\`.\`has_issues\`,\`binary_packages\`.\`is_tested\`,\`binary_packages\`.\`pkgname\`,\`binary_packages\`.\`architecture\`,\`binary_packages\`.\`sub_pkgrel\`+1 FROM \`binary_packages\` JOIN \`pkg_hashes\` ON \`pkg_hashes\`.\`pkgid\`=\`binary_packages\`.\`id\` JOIN \`build_assignments\` ON \`binary_packages\`.\`build_assignment\`=\`build_assignments\`.\`id\` JOIN \`package_sources\` ON \`build_assignments\`.\`package_source\`=\`package_sources\`.\`id\` JOIN \`toolchain_order\` AS \`late\` ON \`package_sources\`.\`pkgbase\`=\`late\`.\`pkgbase\` JOIN \`toolchain_order\` AS \`early\` ON \`early\`.\`number\`<\`late\`.\`number\` AND \`early\`.\`pkgbase\`!=\`late\`.\`pkgbase\` JOIN \`package_sources\` AS \`early_ps\` ON \`early\`.\`pkgbase\`=\`early_ps\`.\`pkgbase\` JOIN \`build_assignments\` AS \`early_ba\` ON \`early_ps\`.\`id\`=\`early_ba\`.\`package_source\` JOIN \`binary_packages\` AS \`early_bp\` ON \`early_ba\`.\`id\`=\`early_bp\`.\`build_assignment\` JOIN \`binary_packages_in_repositories\` AS \`early_bpir\` ON \`early_bp\`.\`id\`=\`early_bpir\`.\`package\` AND \`early_bpir\`.\`repository\`=9 WHERE (\`early_bp\`.\`architecture\`=\`binary_packages\`.\`architecture\` OR \`early_bp\`.\`architecture\`=1 OR \`binary_packages\`.\`architecture\`=1) AND NOT EXISTS (SELECT 1 FROM \`binary_packages\` AS \`early_bp\` JOIN \`binary_packages_in_repositories\` AS \`early_bpir\` ON \`early_bp\`.\`id\`=\`early_bpir\`.\`package\` JOIN \`repositories\` AS \`early_r\` ON \`early_bpir\`.\`repository\`=\`early_r\`.\`id\` WHERE \`early_r\`.\`is_on_master_mirror\` AND \`early_bp\`.\`build_assignment\`=\`early_ba\`.\`id\`);
-- : INSERT IGNORE INTO \`binary_packages_in_repositories\` (\`package\`,\`repository\`,\`is_to_be_deleted\`) SELECT \`new_bp\`.\`id\`,9,0 FROM \`binary_packages\` AS \`built_bp\` JOIN \`pkg_hashes\` ON \`built_bp\`.\`id\`=\`pkg_hashes\`.\`pkgid\` JOIN \`binary_packages\` AS \`new_bp\` ON \`built_bp\`.\`build_assignment\`=\`new_bp\`.\`build_assignment\` AND \`built_bp\`.\`epoch\`=\`new_bp\`.\`epoch\` AND \`built_bp\`.\`pkgver\`=\`new_bp\`.\`pkgver\` AND \`built_bp\`.\`pkgrel\`=\`new_bp\`.\`pkgrel\` AND \`built_bp\`.\`has_issues\`=\`new_bp\`.\`has_issues\` AND \`built_bp\`.\`is_tested\`=\`new_bp\`.\`is_tested\` AND \`built_bp\`.\`pkgname\`=\`new_bp\`.\`pkgname\` AND \`built_bp\`.\`architecture\`=\`new_bp\`.\`architecture\` AND \`built_bp\`.\`sub_pkgrel\`+1=\`new_bp\`.\`sub_pkgrel\`;
-- : INSERT IGNORE INTO \`dependencies\` (\`dependent\`,\`depending_on\`,\`dependency_type\`,\`version\`,\`version_relation\`) SELECT \`new_bp\`.\`id\`,\`dependencies\`.\`depending_on\`,\`dependencies\`.\`dependency_type\`,\`dependencies\`.\`version\`,\`dependencies\`.\`version_relation\` FROM \`dependencies\` JOIN \`binary_packages\` AS \`built_bp\` ON \`dependencies\`.\`dependent\`=\`built_bp\`.\`id\` JOIN \`pkg_hashes\` ON \`built_bp\`.\`id\`=\`pkg_hashes\`.\`pkgid\` JOIN \`binary_packages\` AS \`new_bp\` ON \`built_bp\`.\`build_assignment\`=\`new_bp\`.\`build_assignment\` AND \`built_bp\`.\`epoch\`=\`new_bp\`.\`epoch\` AND \`built_bp\`.\`pkgver\`=\`new_bp\`.\`pkgver\` AND \`built_bp\`.\`pkgrel\`=\`new_bp\`.\`pkgrel\` AND \`built_bp\`.\`has_issues\`=\`new_bp\`.\`has_issues\` AND \`built_bp\`.\`is_tested\`=\`new_bp\`.\`is_tested\` AND \`built_bp\`.\`pkgname\`=\`new_bp\`.\`pkgname\` AND \`built_bp\`.\`architecture\`=\`new_bp\`.\`architecture\` AND \`built_bp\`.\`sub_pkgrel\`+1=\`new_bp\`.\`sub_pkgrel\`;
-- : INSERT IGNORE INTO \`install_target_providers\` (\`package\`,\`install_target\`,\`version\`,\`install_target_is_group\`) SELECT \`new_bp\`.\`id\`,\`install_target_providers\`.\`install_target\`,\`install_target_providers\`.\`version\`,\`install_target_providers\`.\`install_target_is_group\` FROM \`install_target_providers\` JOIN \`binary_packages\` AS \`built_bp\` ON \`install_target_providers\`.\`package\`=\`built_bp\`.\`id\` JOIN \`pkg_hashes\` ON \`built_bp\`.\`id\`=\`pkg_hashes\`.\`pkgid\` JOIN \`binary_packages\` AS \`new_bp\` ON \`built_bp\`.\`build_assignment\`=\`new_bp\`.\`build_assignment\` AND \`built_bp\`.\`epoch\`=\`new_bp\`.\`epoch\` AND \`built_bp\`.\`pkgver\`=\`new_bp\`.\`pkgver\` AND \`built_bp\`.\`pkgrel\`=\`new_bp\`.\`pkgrel\` AND \`built_bp\`.\`has_issues\`=\`new_bp\`.\`has_issues\` AND \`built_bp\`.\`is_tested\`=\`new_bp\`.\`is_tested\` AND \`built_bp\`.\`pkgname\`=\`new_bp\`.\`pkgname\` AND \`built_bp\`.\`architecture\`=\`new_bp\`.\`architecture\` AND \`built_bp\`.\`sub_pkgrel\`+1=\`new_bp\`.\`sub_pkgrel\`;
-- : DELETE \`binary_packages_in_repositories\` FROM \`binary_packages_in_repositories\` JOIN \`pkg_hashes\` ON \`pkg_hashes\`.\`pkgid\`=\`binary_packages_in_repositories\`.\`package\` WHERE \`binary_packages_in_repositories\`.\`repository\`=9;
-- : COMMIT;
-- : UPDATE \`binary_packages\` SET \`binary_packages\`.\`has_issues\`=0, \`binary_packages\`.\`is_tested\`=0 WHERE \`binary_packages\`.\`id\` IN (from_base64("MTA4ODAzOTc=")
-- : );
-- : COMMIT;
-- : UPDATE \`build_slaves\` SET \`build_slaves\`.\`currently_building\`=NULL, \`build_slaves\`.\`last_action\`=NULL, \`build_slaves\`.\`logged_lines\`=NULL, \`build_slaves\`.\`trials\`=NULL WHERE \`build_slaves\`.\`currently_building\`=from_base64("OTc4ODU1Mg==");
-- : COMMIT;
-- : CREATE TEMPORARY TABLE \`loops_to_delete\` (\`loop\` MEDIUMINT);
-- : INSERT IGNORE INTO \`loops_to_delete\` SELECT \`build_dependency_loops\`.\`loop\` FROM \`build_dependency_loops\` JOIN \`binary_packages\` ON \`build_dependency_loops\`.\`build_assignment\`=\`binary_packages\`.\`build_assignment\` JOIN \`binary_packages_in_repositories\` ON \`binary_packages\`.\`id\`=\`binary_packages_in_repositories\`.\`package\` WHERE NOT \`binary_packages_in_repositories\`.\`repository\`=9;
-- : COMMIT;
-- : DELETE FROM \`build_dependency_loops\` WHERE EXISTS (SELECT 1 FROM \`loops_to_delete\` WHERE \`loops_to_delete\`.\`loop\`=\`build_dependency_loops\`.\`loop\`);
-- : DROP TEMPORARY TABLE \`loops_to_delete\`;
-- : END_OF_MYSQL_QUERY
-- : rm "/home/master/builder/work/intentions/intention.5"
CREATE TEMPORARY TABLE `pkg_hashes` (`pkgid` BIGINT, `sha512sum` VARCHAR(128), `key_id` BIGINT);
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2024-09-01T21:24:42.XwY047.infile.1" INTO TABLE `pkg_hashes`;
UPDATE `binary_packages` JOIN `pkg_hashes` ON `pkg_hashes`.`pkgid`=`binary_packages`.`id` SET `binary_packages`.`sha512sum`=`pkg_hashes`.`sha512sum`,`binary_packages`.`signing_key`=`pkg_hashes`.`key_id`;
COMMIT;
CREATE TEMPORARY TABLE `pl` (`pkgid` BIGINT,`lib` VARCHAR(128),`relation` VARCHAR(2),`epoch` MEDIUMINT,`version` VARCHAR(32));
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2024-09-01T21:24:42.XwY047.infile.2" INTO TABLE `pl`;
INSERT IGNORE INTO `install_targets` (`name`) SELECT DISTINCT `pl`.`lib` FROM `pl`;
COMMIT;
INSERT IGNORE INTO `versions` (`epoch`,`version`) SELECT DISTINCT `pl`.`epoch`,`pl`.`version` FROM `pl`;
COMMIT;
INSERT IGNORE INTO `install_target_providers` (`package`,`install_target`,`install_target_is_group`,`version`) SELECT `pl`.`pkgid`,`install_targets`.`id`,0,`versions`.`id` FROM `install_targets` JOIN `pl` ON `pl`.`lib`=`install_targets`.`name` JOIN `versions` ON `versions`.`epoch`=`pl`.`epoch` AND `versions`.`version`=`pl`.`version`;
COMMIT;
CREATE TEMPORARY TABLE `nl` (`pkgid` BIGINT,`dep_type` VARCHAR(32),`lib` VARCHAR(128),`relation` VARCHAR(2),`epoch` MEDIUMINT,`version` VARCHAR(32));
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2024-09-01T21:24:42.XwY047.infile.3" INTO TABLE `nl`;
INSERT IGNORE INTO `install_targets` (`name`) SELECT DISTINCT `nl`.`lib` FROM `nl`;
COMMIT;
INSERT IGNORE INTO `versions` (`epoch`,`version`) SELECT DISTINCT `nl`.`epoch`,`nl`.`version` FROM `nl`;
COMMIT;
DELETE `dependencies` FROM `nl` JOIN `dependencies` ON `dependencies`.`dependent`=`nl`.`pkgid`;
INSERT IGNORE INTO `dependencies` (`dependent`,`depending_on`,`dependency_type`,`version_relation`,`version`) SELECT `nl`.`pkgid`,`install_targets`.`id`,`dependency_types`.`id`,`nl`.`relation`,`versions`.`id` FROM `install_targets` JOIN `nl` ON `nl`.`lib`=`install_targets`.`name` JOIN `dependency_types` ON `dependency_types`.`name`=`nl`.`dep_type` JOIN `versions` ON `versions`.`epoch`=`nl`.`epoch` AND `versions`.`version`=`nl`.`version`;
COMMIT;
UPDATE `build_assignments` SET `build_assignments`.`is_broken`=0, `build_assignments`.`priority`=0, `build_assignments`.`return_date`=NOW() WHERE `build_assignments`.`id`=from_base64("OTc4ODU1Mg==");
COMMIT;
INSERT INTO `binary_packages_in_repositories` (`package`,`repository`,`is_to_be_deleted`) VALUES (10880397,43,0) ON DUPLICATE KEY UPDATE `id`=LAST_INSERT_ID(`binary_packages_in_repositories`.`id`);
SELECT LAST_INSERT_ID();
COMMIT;
INSERT IGNORE INTO `binary_packages` (`build_assignment`,`epoch`,`pkgver`,`pkgrel`,`has_issues`,`is_tested`,`pkgname`,`architecture`,`sub_pkgrel`) SELECT `binary_packages`.`build_assignment`,`binary_packages`.`epoch`,`binary_packages`.`pkgver`,`binary_packages`.`pkgrel`,`binary_packages`.`has_issues`,`binary_packages`.`is_tested`,`binary_packages`.`pkgname`,`binary_packages`.`architecture`,`binary_packages`.`sub_pkgrel`+1 FROM `binary_packages` JOIN `pkg_hashes` ON `pkg_hashes`.`pkgid`=`binary_packages`.`id` JOIN `build_assignments` ON `binary_packages`.`build_assignment`=`build_assignments`.`id` JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id` JOIN `toolchain_order` AS `late` ON `package_sources`.`pkgbase`=`late`.`pkgbase` JOIN `toolchain_order` AS `early` ON `early`.`number`<`late`.`number` AND `early`.`pkgbase`!=`late`.`pkgbase` JOIN `package_sources` AS `early_ps` ON `early`.`pkgbase`=`early_ps`.`pkgbase` JOIN `build_assignments` AS `early_ba` ON `early_ps`.`id`=`early_ba`.`package_source` JOIN `binary_packages` AS `early_bp` ON `early_ba`.`id`=`early_bp`.`build_assignment` JOIN `binary_packages_in_repositories` AS `early_bpir` ON `early_bp`.`id`=`early_bpir`.`package` AND `early_bpir`.`repository`=9 WHERE (`early_bp`.`architecture`=`binary_packages`.`architecture` OR `early_bp`.`architecture`=1 OR `binary_packages`.`architecture`=1) AND NOT EXISTS (SELECT 1 FROM `binary_packages` AS `early_bp` JOIN `binary_packages_in_repositories` AS `early_bpir` ON `early_bp`.`id`=`early_bpir`.`package` JOIN `repositories` AS `early_r` ON `early_bpir`.`repository`=`early_r`.`id` WHERE `early_r`.`is_on_master_mirror` AND `early_bp`.`build_assignment`=`early_ba`.`id`);
INSERT IGNORE INTO `binary_packages_in_repositories` (`package`,`repository`,`is_to_be_deleted`) SELECT `new_bp`.`id`,9,0 FROM `binary_packages` AS `built_bp` JOIN `pkg_hashes` ON `built_bp`.`id`=`pkg_hashes`.`pkgid` JOIN `binary_packages` AS `new_bp` ON `built_bp`.`build_assignment`=`new_bp`.`build_assignment` AND `built_bp`.`epoch`=`new_bp`.`epoch` AND `built_bp`.`pkgver`=`new_bp`.`pkgver` AND `built_bp`.`pkgrel`=`new_bp`.`pkgrel` AND `built_bp`.`has_issues`=`new_bp`.`has_issues` AND `built_bp`.`is_tested`=`new_bp`.`is_tested` AND `built_bp`.`pkgname`=`new_bp`.`pkgname` AND `built_bp`.`architecture`=`new_bp`.`architecture` AND `built_bp`.`sub_pkgrel`+1=`new_bp`.`sub_pkgrel`;
INSERT IGNORE INTO `dependencies` (`dependent`,`depending_on`,`dependency_type`,`version`,`version_relation`) SELECT `new_bp`.`id`,`dependencies`.`depending_on`,`dependencies`.`dependency_type`,`dependencies`.`version`,`dependencies`.`version_relation` FROM `dependencies` JOIN `binary_packages` AS `built_bp` ON `dependencies`.`dependent`=`built_bp`.`id` JOIN `pkg_hashes` ON `built_bp`.`id`=`pkg_hashes`.`pkgid` JOIN `binary_packages` AS `new_bp` ON `built_bp`.`build_assignment`=`new_bp`.`build_assignment` AND `built_bp`.`epoch`=`new_bp`.`epoch` AND `built_bp`.`pkgver`=`new_bp`.`pkgver` AND `built_bp`.`pkgrel`=`new_bp`.`pkgrel` AND `built_bp`.`has_issues`=`new_bp`.`has_issues` AND `built_bp`.`is_tested`=`new_bp`.`is_tested` AND `built_bp`.`pkgname`=`new_bp`.`pkgname` AND `built_bp`.`architecture`=`new_bp`.`architecture` AND `built_bp`.`sub_pkgrel`+1=`new_bp`.`sub_pkgrel`;
INSERT IGNORE INTO `install_target_providers` (`package`,`install_target`,`version`,`install_target_is_group`) SELECT `new_bp`.`id`,`install_target_providers`.`install_target`,`install_target_providers`.`version`,`install_target_providers`.`install_target_is_group` FROM `install_target_providers` JOIN `binary_packages` AS `built_bp` ON `install_target_providers`.`package`=`built_bp`.`id` JOIN `pkg_hashes` ON `built_bp`.`id`=`pkg_hashes`.`pkgid` JOIN `binary_packages` AS `new_bp` ON `built_bp`.`build_assignment`=`new_bp`.`build_assignment` AND `built_bp`.`epoch`=`new_bp`.`epoch` AND `built_bp`.`pkgver`=`new_bp`.`pkgver` AND `built_bp`.`pkgrel`=`new_bp`.`pkgrel` AND `built_bp`.`has_issues`=`new_bp`.`has_issues` AND `built_bp`.`is_tested`=`new_bp`.`is_tested` AND `built_bp`.`pkgname`=`new_bp`.`pkgname` AND `built_bp`.`architecture`=`new_bp`.`architecture` AND `built_bp`.`sub_pkgrel`+1=`new_bp`.`sub_pkgrel`;
DELETE `binary_packages_in_repositories` FROM `binary_packages_in_repositories` JOIN `pkg_hashes` ON `pkg_hashes`.`pkgid`=`binary_packages_in_repositories`.`package` WHERE `binary_packages_in_repositories`.`repository`=9;
COMMIT;
UPDATE `binary_packages` SET `binary_packages`.`has_issues`=0, `binary_packages`.`is_tested`=0 WHERE `binary_packages`.`id` IN (from_base64("MTA4ODAzOTc=")
);
COMMIT;
UPDATE `build_slaves` SET `build_slaves`.`currently_building`=NULL, `build_slaves`.`last_action`=NULL, `build_slaves`.`logged_lines`=NULL, `build_slaves`.`trials`=NULL WHERE `build_slaves`.`currently_building`=from_base64("OTc4ODU1Mg==");
COMMIT;
CREATE TEMPORARY TABLE `loops_to_delete` (`loop` MEDIUMINT);
INSERT IGNORE INTO `loops_to_delete` SELECT `build_dependency_loops`.`loop` FROM `build_dependency_loops` JOIN `binary_packages` ON `build_dependency_loops`.`build_assignment`=`binary_packages`.`build_assignment` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` WHERE NOT `binary_packages_in_repositories`.`repository`=9;
COMMIT;
DELETE FROM `build_dependency_loops` WHERE EXISTS (SELECT 1 FROM `loops_to_delete` WHERE `loops_to_delete`.`loop`=`build_dependency_loops`.`loop`);
DROP TEMPORARY TABLE `loops_to_delete`;