Index: openacs-4/packages/press/www/admin/template-admin.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/press/www/admin/template-admin.tcl,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/press/www/admin/template-admin.tcl	5 Sep 2002 13:12:13 -0000	1.2
+++ openacs-4/packages/press/www/admin/template-admin.tcl	31 Oct 2003 16:09:23 -0000	1.3
@@ -23,17 +23,7 @@
 # Grab the sample information
 
 
-db_foreach press_templates {
-    select t.template_id,
-           t.template_name,
-           t.template_adp,
-           count(p.template_id) as template_usage
-    from   press_templates t, 
-           press_items_approved p
-    where  t.template_id = p.template_id(+)
-    group  by t.template_id, t.template_name, t.template_adp
-    order  by t.template_name
-} {
+db_foreach press_templates {} {
 
     set template_item "
     <li>$template_name (used $template_usage time[expr {$template_usage != 1 ? "s" : ""}])