Index: openacs-4/packages/acs-admin/www/users/registration-history-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/Attic/registration-history-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-admin/www/users/registration-history-postgresql.xql 29 Apr 2001 00:47:48 -0000 1.1 +++ openacs-4/packages/acs-admin/www/users/registration-history-postgresql.xql 11 Nov 2003 14:30:35 -0000 1.2 @@ -9,6 +9,7 @@ from users, acs_objects where users.user_id = acs_objects.object_id and creation_date is not null +and user_id <> 0 group by to_char(creation_date,'YYYYMM'), to_char(creation_date,'Month'), to_char(creation_date,'YYYY') order by 1