lib/mysql-functions: mysql_query_has_pending_dependencies(): do not use external stuff in internal JOIN...ONs

1 files changed, 3 insertions, 3 deletions

diff --git a/lib/mysql-functions b/lib/mysql-functions
index 7cafb79..2c81b57 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -888,10 +888,10 @@ mysql_query_has_pending_dependencies() {
           "${repository_ids__any_build_list}"
         printf ' JOIN `architecture_compatibilities`'
         printf ' ON `architecture_compatibilities`.`built_for`=`dep_bp`.`architecture`'
-        printf ' AND `architecture_compatibilities`.`runs_on`=%s' \
-          "$1"
         printf ' AND `architecture_compatibilities`.`fully_compatible`'
         printf ' WHERE `l_itps`.`install_target`=`l_deps`.`depending_on`'
+        printf ' AND `architecture_compatibilities`.`runs_on`=%s' \
+          "$1"
         # version is irelevant: either the package is built and we don't
         # care or the package is not built and we don't know
       printf '),'
@@ -905,9 +905,9 @@ mysql_query_has_pending_dependencies() {
         mysql_join_binary_packages_binary_packages_in_repositories 'dep_bp' 'dep_bpir'
         mysql_join_binary_packages_in_repositories_repositories 'dep_bpir' 'dep_r'
         printf ' AND `dep_r`.`is_on_master_mirror`'
+        printf ' WHERE `l_itps`.`install_target`=`l_deps`.`depending_on`'
         printf ' AND `dep_r`.`architecture`=%s' \
           "$1"
-        printf ' WHERE `l_itps`.`install_target`=`l_deps`.`depending_on`'
         printf ' AND '
         mysql_query_ordering_correct \
           '`l_dep_vs`.`order`' \