-- called by /home/master/builder/bin/get-package-updates
SELECT DISTINCT `ncy_ba`.`id`,`nt_ba`.`id` FROM `dependencies` JOIN `dependency_types` ON `dependencies`.`dependency_type`=`dependency_types`.`id` 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 `ncy_bp` ON `install_target_providers`.`package`=`ncy_bp`.`id` JOIN `binary_packages` AS `nt_bp` ON `dependencies`.`dependent`=`nt_bp`.`id` JOIN `binary_packages_in_repositories` AS `ncy_bpir` ON `ncy_bp`.`id`=`ncy_bpir`.`package` JOIN `build_assignments` AS `ncy_ba` ON `ncy_bp`.`build_assignment`=`ncy_ba`.`id` JOIN `architecture_compatibilities` AS `ncy_ac` ON `ncy_ac`.`built_for`=`ncy_ba`.`architecture` AND `ncy_ac`.`runs_on`=3 AND `ncy_ac`.`fully_compatible` JOIN `binary_packages_in_repositories` AS `nt_bpir` ON `nt_bp`.`id`=`nt_bpir`.`package` JOIN `build_assignments` AS `nt_ba` ON `nt_bp`.`build_assignment`=`nt_ba`.`id` JOIN `architecture_compatibilities` AS `nt_ac` ON `nt_ac`.`built_for`=`nt_ba`.`architecture` AND `nt_ac`.`runs_on`=3 AND `nt_ac`.`fully_compatible` WHERE `nt_bpir`.`repository`=9 AND `ncy_bpir`.`repository`=9 AND `dependency_types`.`relevant_for_building` AND (`dependency_types`.`relevant_for_binary_packages` OR NOT EXISTS (SELECT 1 FROM `binary_packages_in_repositories` AS `subst_bpir` JOIN `repositories` AS `subst_r` ON `subst_bpir`.`repository`=`subst_r`.`id` AND `subst_r`.`is_on_master_mirror` JOIN `binary_packages` AS `subst_bp` ON `subst_bpir`.`package`=`subst_bp`.`id` JOIN `build_assignments` AS `subst_ba` ON `subst_bp`.`build_assignment`=`subst_ba`.`id` JOIN `architecture_compatibilities` AS `subst_ac` ON `subst_ac`.`built_for`=`subst_ba`.`architecture` AND `subst_ac`.`runs_on`=3 AND `subst_ac`.`fully_compatible` JOIN `install_target_providers` AS `subst_itp` ON `subst_bpir`.`package`=`subst_itp`.`package` JOIN `versions` AS `subst_itp_v` ON `subst_itp`.`version`=`subst_itp_v`.`id` WHERE `subst_itp`.`install_target`=`dependencies`.`depending_on` AND ((`dependencies`.`version_relation`="<" AND `subst_itp_v`.`order`<`dependencies_versions`.`order`) OR (`dependencies`.`version_relation`="<=" AND `subst_itp_v`.`order`<=`dependencies_versions`.`order`) OR (`dependencies`.`version_relation`=">" AND `subst_itp_v`.`order`>`dependencies_versions`.`order`) OR (`dependencies`.`version_relation`=">=" AND `subst_itp_v`.`order`>=`dependencies_versions`.`order`) OR (`dependencies`.`version_relation`="=" AND `subst_itp_v`.`order`=`dependencies_versions`.`order`))));