Index: openacs-4/packages/lars-blogger/www/blog-months-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/www/blog-months-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/lars-blogger/www/blog-months-postgresql.xql	14 Sep 2002 18:37:58 -0000	1.2
+++ openacs-4/packages/lars-blogger/www/blog-months-postgresql.xql	28 Aug 2003 09:41:55 -0000	1.3
@@ -3,7 +3,7 @@
 <queryset>
     <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
-    <fullquery name="months">
+    <fullquery name="all_blog_months">
         <querytext>
 			select date_trunc('month', entry_date) as month_date,
 			       to_char(date_trunc('month', entry_date), 'fmMonthfm YYYY')
@@ -18,4 +18,22 @@
         </querytext>
     </fullquery>
 
+    <fullquery name="one_blog_months">
+        <querytext>
+			select date_trunc('month', entry_date) as month_date,
+			       to_char(date_trunc('month', entry_date), 'fmMonthfm YYYY')
+					  as date_pretty,
+			       to_char(date_trunc('month', entry_date), 'YYYY/MM/')
+					  as month_url_stub
+			 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    draft_p = 'f'
+			and    screen_name = :screen_name
+			group  by month_date
+			order  by month_date desc
+        </querytext>
+    </fullquery>
+
 </queryset>