Index: openacs-4/packages/ecommerce/www/product-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/product-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/ecommerce/www/product-postgresql.xql	20 Jul 2001 18:26:42 -0000	1.3
+++ openacs-4/packages/ecommerce/www/product-postgresql.xql	26 May 2002 04:36:50 -0000	1.4
@@ -1,26 +1,24 @@
 <?xml version="1.0"?>
 
 <queryset>
-   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+  <rdbms>
+    <type>postgresql</type>
+    <version>7.1</version>
+  </rdbms>
 
-<fullquery name="find_a_good_category">      
-      <querytext>
+  <fullquery name="find_a_good_category">      
+    <querytext>
+      select * 
+      from (select category_id, (select count(*)
+               from ec_subcategories s
+               where s.category_id = m.category_id) as subcount, (select count(*)
+               from ec_subsubcategories ss
+               where ss.subcategory_id = m.category_id) as subsubcount
+            from ec_category_product_map m
+            where product_id = :product_id
+            order by subcount, subsubcount, category_id) some_name
+      limit 1
+    </querytext>
+  </fullquery>
 
-    select * from 
-        (select category_id,
-               (select count(*)
-                  from ec_subcategories s
-                 where s.category_id = m.category_id) as subcount,
-               (select count(*)
-                  from ec_subsubcategories ss
-                 where ss.subcategory_id = m.category_id) as subsubcount
-          from ec_category_product_map m
-         where product_id = :product_id
-      order by subcount, subsubcount, category_id) some_name
-    limit 1
-
-      </querytext>
-</fullquery>
-
- 
 </queryset>