DELETE `build_assignments`,`binary_packages`,`binary_packages_in_repositories` FROM `binary_packages` JOIN `build_assignments` ON `binary_packages`.`build_assignment`=`build_assignments`.`id` JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id` JOIN `binary_packages_in_repositories` AS `keep_bpir` ON `binary_packages`.`id`=`keep_bpir`.`package` LEFT JOIN `repositories` AS `keep_r` ON `keep_bpir`.`repository`=`keep_r`.`id` AND `all_r`.`stability` NOT IN (5,6);
 JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` WHERE `package_sources`.`pkgbase`=from_base64("cHl0aG9uLW9wZW5zdGFja3Nkaw==") AND `keep_r`.`id` IS NULL AND `repositories`.`stability` IN (5,6);
DELETE `binary_packages`,`binary_packages_in_repositories` FROM `binary_packages` JOIN `build_assignments` ON `binary_packages`.`build_assignment`=`build_assignments`.`id` JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` WHERE `package_sources`.`pkgbase`=from_base64("cHl0aG9uLW9wZW5zdGFja3Nkaw==") AND `repositories`.`stability` IN (5,6);
UPDATE `binary_packages_in_repositories` JOIN `binary_packages` ON `binary_packages_in_repositories`.`package`=`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` SET `binary_packages_in_repositories`.`is_to_be_deleted`=0 WHERE `package_sources`.`pkgbase`=from_base64("cHl0aG9uLW9wZW5zdGFja3Nkaw==");