UPDATE `build_assignments` JOIN (SELECT `s_ba`.`id` AS `build_assignment`,MAX(`g_ba`.`priority`) AS `priority` FROM `build_assignments` AS `g_ba` JOIN `binary_packages` AS `g_bp` ON `g_ba`.`id`=`g_bp`.`build_assignment` JOIN `binary_packages_in_repositories` AS `g_bpir` ON `g_bp`.`id`=`g_bpir`.`package` AND `g_bpir`.`repository`=9 JOIN `dependencies` ON `g_bp`.`id`=`dependencies`.`dependent` JOIN `dependency_types` ON `dependencies`.`dependency_type`=`dependency_types`.`id` AND `dependency_types`.`relevant_for_binary_packages` JOIN `install_target_providers` ON `dependencies`.`depending_on`=`install_target_providers`.`install_target` JOIN `versions` AS `install_target_providers_versions` ON `install_target_providers`.`version`=`install_target_providers_versions`.`id` JOIN `versions` AS `dependencies_versions` ON `dependencies`.`version`=`dependencies_versions`.`id` AND ((`dependencies`.`version_relation`="<" AND `install_target_providers_versions`.`order`<`dependencies_versions`.`order`) OR (`dependencies`.`version_relation`="<=" AND `install_target_providers_versions`.`order`<=`dependencies_versions`.`order`) OR (`dependencies`.`version_relation`=">" AND `install_target_providers_versions`.`order`>`dependencies_versions`.`order`) OR (`dependencies`.`version_relation`=">=" AND `install_target_providers_versions`.`order`>=`dependencies_versions`.`order`) OR (`dependencies`.`version_relation`="=" AND `install_target_providers_versions`.`order`=`dependencies_versions`.`order`)) JOIN `binary_packages` AS `s_bp` ON `install_target_providers`.`package`=`s_bp`.`id` JOIN `binary_packages_in_repositories` AS `s_bpir` ON `s_bp`.`id`=`s_bpir`.`package` AND `s_bpir`.`repository`=9 JOIN `architecture_compatibilities` AS `ac_a` ON `ac_a`.`fully_compatible` AND `ac_a`.`built_for`=`g_bp`.`architecture` JOIN `architecture_compatibilities` AS `ac_b` ON `ac_b`.`fully_compatible` AND `ac_b`.`built_for`=`s_bp`.`architecture` AND `ac_a`.`runs_on`=`ac_b`.`runs_on` JOIN `build_assignments` AS `s_ba` ON `s_bp`.`build_assignment`=`s_ba`.`id` GROUP BY `s_ba`.`id`) AS `sub_q` ON `sub_q`.`build_assignment`=`build_assignments`.`id` SET `build_assignments`.`priority`=`sub_q`.`priority` WHERE `build_assignments`.`priority`<`sub_q`.`priority` AND NOT `build_assignments`.`is_broken`;
SELECT row_count();