From 4e9339318bb80acf62145f932c65e0c89ad6ee99 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Thu, 29 Mar 2018 20:24:09 +0200
Subject: bin/wtf: fix joins

---
 bin/wtf | 6 ++----
 1 file changed, 2 insertions(+), 4 deletions(-)

(limited to 'bin/wtf')

diff --git a/bin/wtf b/bin/wtf
index b3e29a6..4c03103 100755
--- a/bin/wtf
+++ b/bin/wtf
@@ -32,11 +32,9 @@ result=$(
     printf ' FROM `binary_packages`'
     mysql_join_binary_packages_architectures
     mysql_join_binary_packages_repositories
-    mysql_join_binary_packages_file_providers
-    printf ' PARTITION (p%s)' \
+    printf ' JOIN `file_providers` PARTITION (p%s) ON `file_providers`.`package`=`binary_packages`.`id`' \
       "${partition}"
-    mysql_join_file_providers_files
-    printf ' PARTITION (p%s)' \
+    printf ' JOIN `files` PARTITION (p%s) ON `files`.`id`=`file_providers`.`file` AND `files`.`name_hash`=`file_providers`.`file_name_hash`' \
       "${partition}"
     printf ' WHERE `files`.`name_hash`=%s' \
       "${hash}"
-- 
cgit v1.2.3