X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=madison;fp=madison;h=9a830262def383e930583bdc761826860acd530a;hb=4af8ee1686e801c689b2c7d988b8b8feff00a1b7;hp=1ce965d13be125cc57fefcabe4a6a0b1d45d110b;hpb=d2410f3d14d73c91f169f05a33fc74f5f47cc2c7;p=dak.git

diff --git a/madison b/madison
index 1ce965d1..9a830262 100755
--- a/madison
+++ b/madison
@@ -1,8 +1,8 @@
 #!/usr/bin/env python
 
 # Display information about package(s) (suite, version, etc.)
-# Copyright (C) 2000, 2001, 2002  James Troup <james@nocrew.org>
-# $Id: madison,v 1.23 2003-01-02 18:11:20 troup Exp $
+# Copyright (C) 2000, 2001, 2002, 2003  James Troup <james@nocrew.org>
+# $Id: madison,v 1.24 2003-02-10 18:05:49 troup Exp $
 
 # This program is free software; you can redistribute it and/or modify
 # it under the terms of the GNU General Public License as published by
@@ -93,7 +93,7 @@ def main ():
     if Options["Source-And-Binary"]:
         new_packages = [];
         for package in packages:
-            q = projectB.query("SELECT DISTINCT package FROM binaries WHERE EXISTS (SELECT s.source FROM source s WHERE binaries.source = s.id AND s.source %s '%s')" % (comparison_operator, package));
+            q = projectB.query("SELECT DISTINCT package FROM binaries JOIN source ON binaries.source = source.id WHERE source.source %s '%s'" % (comparison_operator, package));
             new_packages.extend(map(lambda x: x[0], q.getresult()));
             new_packages.append(package);
         packages = new_packages;