Index: openacs-4/packages/lars-blogger/tcl/entry-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/entry-procs-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/lars-blogger/tcl/entry-procs-postgresql.xql	1 Oct 2003 19:12:05 -0000	1.4
+++ openacs-4/packages/lars-blogger/tcl/entry-procs-postgresql.xql	8 Dec 2003 04:47:53 -0000	1.5
@@ -5,30 +5,31 @@
 
     <fullquery name="lars_blogger::entry::get.select_entry">
         <querytext>
-		    select b.entry_id,  
-                           b.title, 
-                           b.title_url, 
-                           b.category_id, 
-                           b.content, 
-                           b.content_format, 
-                           b.draft_p, 
-			   o.creation_user as user_id,
-                           to_char(b.entry_date, 'YYYY-MM-DD') as entry_date,
-		           to_char(b.entry_date, 'fmDayfm, fmMonthfm fmDDfm, YYYY') as entry_date_pretty, 
-        		   p.first_names as poster_first_names,
-		           p.last_name as poster_last_name,
-		           to_char(b.posted_date , 'HH24:MI') as posted_time_pretty,
-                           b.package_id,
-		           (select count(gc.comment_id) 
-		            from general_comments gc, cr_revisions cr 
-		            where gc.object_id = entry_id
-		            and   content_item__get_live_revision(gc.comment_id) = cr.revision_id) as num_comments
-		    from   pinds_blog_entries b,
-                           acs_objects o,
-                           persons p
-		    where  b.entry_id = :entry_id
-                    and    o.object_id = b.entry_id
-                    and    p.person_id = o.creation_user
+            select b.entry_id,  
+                   b.title, 
+                   b.title_url, 
+                   b.category_id, 
+                   b.content, 
+                   b.content_format, 
+                   b.draft_p, 
+                   o.creation_user as user_id,
+                   to_char(b.entry_date, 'YYYY-MM-DD') as entry_date,
+                   to_char(b.entry_date, 'fmDayfm, fmMonthfm fmDDfm, YYYY') as entry_date_pretty, 
+                   p.first_names as poster_first_names,
+                   p.last_name as poster_last_name,
+                   to_char(b.posted_date , 'HH24:MI') as posted_time_pretty,
+                   b.package_id,
+                   (select count(gc.comment_id) 
+                    from general_comments gc, cr_revisions cr 
+                    where gc.object_id = entry_id
+                    and   content_item__get_live_revision(gc.comment_id) = cr.revision_id) as num_comments
+            from   pinds_blog_entries b,
+                   acs_objects o,
+                   persons p
+            where  b.entry_id = :entry_id
+            and    o.object_id = b.entry_id
+            and    p.person_id = o.creation_user
+            and    b.deleted_p = 'f'
         </querytext>
     </fullquery>