SELECT `a_bp`.`build_assignment`,`b_bp`.`build_assignment` FROM `binary_packages` AS `a_bp` JOIN `binary_packages_in_repositories` AS `a_bpir` ON `a_bp`.`id`=`a_bpir`.`package` AND `a_bpir`.`repository`=9 JOIN `dependencies` ON `a_bp`.`id`=`dependencies`.`dependent` 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 `b_bp` ON `install_target_providers`.`package`=`b_bp`.`id``dependency_types`.`relevant_for_binary_packages` JOIN `binary_packages_in_repositories` AS `b_bpir` ON `b_bp`.`id`=`b_bpir`.`package` AND `a_bpir`.`repository`=9 WHERE `a_bp`.`architecture`=`b_bp`.`architecture` OR `a_bp`.`architecture`=1 OR `b_bp`.`architecture`=1