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` 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("c2RyYW5nZWw=") 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("c2RyYW5nZWw=");