bin/db-update: FROM_stability - not TO_stability

1 files changed, 3 insertions, 4 deletions

diff --git a/bin/db-update b/bin/db-update
index 6f4096c..f09db2d 100755
--- a/bin/db-update
+++ b/bin/db-update
@@ -186,6 +186,8 @@ for source_stability in \
       printf ' FROM `binary_packages_in_repositories` AS `new_bpir`'
       mysql_join_binary_packages_in_repositories_binary_packages 'new_bpir' 'new_bp'
       mysql_join_binary_packages_in_repositories_repositories 'new_bpir' 'from_r'
+      printf ' AND `from_r`.`stability`=%s' \
+        "${source_stability}"
       printf ' AND `from_r`.`is_on_master_mirror`'
       mysql_join_binary_packages_build_assignments 'new_bp'
       mysql_join_build_assignments_package_sources
@@ -194,14 +196,11 @@ for source_stability in \
       printf ' AND `repository_moves`.`from_repository`=`from_r`.`id`'
       printf ' JOIN `repositories` AS `to_r`'
       printf ' ON `repository_moves`.`to_repository`=`to_r`.`id`'
-      printf ' AND `to_r`.`stability`=%s' \
-        "${source_stability}"
       printf ' JOIN `binary_packages` AS `old_bp`'
       printf ' ON `new_bp`.`pkgname`=`old_bp`.`pkgname`'
       mysql_join_binary_packages_binary_packages_in_repositories 'old_bp' 'old_bpir'
       mysql_join_binary_packages_in_repositories_repositories 'old_bpir' 'old_r'
-      printf ' AND `old_r`.`stability`=%s' \
-        "${source_stability}"
+      printf ' AND `old_r`.`stability`=`to_r`.`stability`'
       printf ' AND `old_r`.`architecture`=`to_r`.`architecture`'
       mysql_join_binary_packages_dependencies 'old_bp'
       mysql_join_dependencies_dependency_types