Index: openacs-4/packages/bug-tracker/www/patch-list.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/patch-list.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/bug-tracker/www/patch-list.xql	26 Sep 2003 06:40:22 -0000	1.1
+++ openacs-4/packages/bug-tracker/www/patch-list.xql	26 Sep 2003 08:10:36 -0000	1.2
@@ -7,27 +7,15 @@
       </querytext>
 </partialquery>
 
-<fullquery name="select_versions">
+<partialquery name="apply_to_version_where_clause">
       <querytext>
-
-                select v.version_name,
-                       v.version_id,
-                       (select count(*) 
-                        from   bt_patches p 
-                        where  p.project_id = :package_id 
-                        and    p.apply_to_version = v.version_id
-                       ) as count
-                from   bt_versions v
-                where  exists (select 1 from bt_patches p2
-                               where p2.apply_to_version = v.version_id)
-                order  by v.version_name
-
+                bt_patches.apply_to_version = :apply_to_version
       </querytext>
-</fullquery>
+</partialquery>
 
-<partialquery name="apply_to_version_where_clause">
+<partialquery name="apply_to_version_null_where_clause">
       <querytext>
-                bt_patches.apply_to_version = :apply_to_version
+                bt_patches.apply_to_version is null
       </querytext>
 </partialquery>