Index: openacs-4/packages/acs-admin/www/apm/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/apm/index-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-admin/www/apm/index-postgresql.xql	4 May 2001 06:04:28 -0000	1.2
+++ openacs-4/packages/acs-admin/www/apm/index-postgresql.xql	5 May 2001 17:39:19 -0000	1.3
@@ -13,7 +13,9 @@
              and   v2.installed_p
              and   apm_package_version__sortable_version_name(v2.version_name) >
                    apm_package_version__sortable_version_name(v.version_name)) as  superseded_p,
-            (select count(*) where item_id is not null) as tarball_p
+            (select count(*) 
+               from cr_revisions 
+              where revision_id = content_item__get_latest_revision(item_id)) as tarball_p
         from    apm_package_versions v, apm_package_types t
         where  t.package_key = v.package_key
         [ad_dimensional_sql $dimensional_list where and]