bin/why-dont-you: match repositories.architecture, too

1 files changed, 16 insertions, 5 deletions

diff --git a/bin/why-dont-you b/bin/why-dont-you
index 0ad6e7e..63b96e9 100755
--- a/bin/why-dont-you
+++ b/bin/why-dont-you
@@ -225,14 +225,25 @@ case "${action}" in
           printf ' IF(`binary_packages`.`has_issues`,1,0)'
           printf ' FROM `binary_packages_in_repositories`'
           mysql_join_binary_packages_in_repositories_repositories
+          mysql_join_repositories_architectures
           mysql_join_binary_packages_in_repositories_binary_packages
           printf ' WHERE `repositories`.`stability`=%s' \
             "${from_stability}"
-          printf ' AND `binary_packages`.`pkgname`=from_base64("%s")' \
-            "$(
-              printf '%s' "${pkgname}" | \
-                base64 -w0
-            )"
+          printf ' AND ('
+            printf '`binary_packages`.`pkgname`=from_base64("%s")' \
+              "$(
+                printf '%s' "${pkgname}" | \
+                  base64 -w0
+              )"
+            printf 'OR CONCAT('
+              printf '`architectures`.`name`,"/",'
+              printf '`binary_packages`.`pkgname`'
+            printf ')=from_base64("%s")' \
+              "$(
+                printf '%s' "${pkgname}" | \
+                  base64 -w0
+              )"
+          printf ');\n'
         } | \
           mysql_run_query 'unimportant' | \
           tr '\t' ' '