--- udd/web/cgi-bin/sources_in_unstable_but_not_in_testing_by_popcon_max.cgi	2008/07/28 12:41:58	950
+++ udd/web/cgi-bin/sources_in_unstable_but_not_in_testing_by_popcon_max.cgi	2008/07/28 16:49:58	966
@@ -8,14 +8,14 @@
 
 my $dbh = DBI->connect("dbi:Pg:dbname=udd") or die $!;
 my $sth = $dbh->prepare(<<EOF
-	SELECT DISTINCT unstable.package, (vote + popcon_src_max.old + recent + nofiles) as pvote
+	SELECT DISTINCT unstable.package, insts
         FROM (SELECT DISTINCT package FROM sources
                 WHERE distribution = 'debian' and release = 'sid')
           AS unstable,
              popcon_src_max
         WHERE NOT EXISTS (SELECT * FROM sources WHERE distribution = 'debian'
                           AND release = 'lenny' and package = unstable.package)
-              AND popcon_src_max.package = unstable.package AND popcon_src_max.distribution = 'debian' ORDER BY pvote DESC;
+              AND popcon_src_max.package = unstable.package AND popcon_src_max.distribution = 'debian' ORDER BY insts DESC;
 EOF
 	);