Index: openacs-4/packages/lars-blogger/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/www/index-postgresql.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/lars-blogger/www/index-postgresql.xql	3 Jul 2003 18:37:04 -0000	1.1.2.1
+++ openacs-4/packages/lars-blogger/www/index-postgresql.xql	3 Jul 2003 18:47:40 -0000	1.1.2.2
@@ -5,12 +5,12 @@
 
     <fullquery name="bloggers">
         <querytext>
-		    select distinct screen_name
+		    select distinct u.screen_name, u.user_id
 		    from   pinds_blog_entries e join 
 		           acs_objects o on (o.object_id = e.entry_id) join 
 		           users u on (u.user_id = o.creation_user)
-		    where  package_id = :package_id
-                    and    screen_name != ''
+		    where  e.package_id = :package_id
+                    and    u.screen_name != ''
         </querytext>
     </fullquery>