From aa640a0289438069270d12bc532636ba2ed4940e Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 26 Feb 2020 14:09:02 +0100 Subject: bin/why-dont-you: fix query regarding stability --- bin/why-dont-you | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) diff --git a/bin/why-dont-you b/bin/why-dont-you index 06edacb..9b50427 100755 --- a/bin/why-dont-you +++ b/bin/why-dont-you @@ -301,9 +301,7 @@ case "${action}" in mysql_join_binary_packages_binary_packages_in_repositories 'itp_bp' 'itp_bpir' mysql_join_binary_packages_in_repositories_repositories 'itp_bpir' 'itp_r' printf ' AND `itp_r`.`architecture`=`repositories`.`architecture`' - printf ' JOIN `repository_stability_relations`' - printf ' ON `repository_stability_relations`.`more_stable`=`repositories`.`stability`' - printf ' AND `repository_stability_relations`.`less_stable`=`itp_r`.`stability`' + printf ' AND `repositories`.`stability`=`itp_r`.`stability`' printf ') AS `sub_q`' printf ' GROUP BY `sub_q`.`id`;\n' -- cgit v1.2.3-70-g09d2