INSERT IGNORE INTO `binary_packages_in_repositories` (`package`,`repository`,`last_moved`,`is_to_be_deleted`) SELECT `binary_packages`.`id`,`d_r`.`id`,NOW(),1 FROM `architectures` AS `d_a` JOIN `architecture_compatibilities` AS `a_c` ON `a_c`.`runs_on`=`d_a`.`id` AND `d_a`.`name`=from_base64("aTQ4Ng==") JOIN `build_assignments` ON (`a_c`.`built_for`=`build_assignments`.`architecture` OR `d_a`.`name`="any") JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id` AND `package_sources`.`pkgbase`=from_base64("Z3JhbmF0aWVy") JOIN `binary_packages` ON `build_assignments`.`id`=`binary_packages`.`build_assignment` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` AND `repositories`.`stability` in (5,7) JOIN `architectures` AS `ba_a` ON `build_assignments`.`architecture`=`ba_a`.`id` JOIN `repositories` AS `d_r` ON (`d_r`.`architecture`=`ba_a`.`id` OR `ba_a`.`name`="any") AND `d_r`.`stability`=6;
COMMIT;
DELETE `binary_packages_in_repositories` FROM `architectures` AS `d_a` JOIN `architecture_compatibilities` AS `a_c` ON `a_c`.`runs_on`=`d_a`.`id` AND `d_a`.`name`=from_base64("aTQ4Ng==") JOIN `build_assignments` ON (`a_c`.`built_for`=`build_assignments`.`architecture` OR `d_a`.`name`="any") JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id` AND `package_sources`.`pkgbase`=from_base64("Z3JhbmF0aWVy") JOIN `binary_packages` ON `build_assignments`.`id`=`binary_packages`.`build_assignment` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` AND `repositories`.`stability` in (5,7);
COMMIT;
UPDATE `architectures` AS `d_a` JOIN `architecture_compatibilities` AS `a_c` ON `a_c`.`runs_on`=`d_a`.`id` AND `d_a`.`name`=from_base64("aTQ4Ng==") JOIN `build_assignments` ON (`a_c`.`built_for`=`build_assignments`.`architecture` OR `d_a`.`name`="any") JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id` AND `package_sources`.`pkgbase`=from_base64("Z3JhbmF0aWVy") JOIN `binary_packages` ON `build_assignments`.`id`=`binary_packages`.`build_assignment` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` SET `binary_packages_in_repositories`.`is_to_be_deleted`=1;