Index: openacs-4/packages/photo-album/www/album-export.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/photo-album/www/album-export.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/photo-album/www/album-export.xql	23 Apr 2006 10:10:56 -0000	1.1.2.1
@@ -0,0 +1,46 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="get_photo_info">      
+      <querytext>
+      select
+ pp.caption,
+ pp.story,
+ cr.title as file_name,
+ cr.description,
+ i.height as height,
+ i.width as width,
+ i.image_id as image_id,
+ cr.revision_id as live_revision,
+ ci.parent_id as album_id
+from cr_items ci,
+  cr_revisions cr,
+  pa_photos pp,
+  cr_items ci2,
+  cr_child_rels ccr2,
+  images i
+where cr.revision_id = pp.pa_photo_id
+  and ci.live_revision = cr.revision_id
+  and ci.item_id = ccr2.parent_id
+  and ccr2.child_id = ci2.item_id
+  and ccr2.relation_tag = 'base'
+  and ci2.live_revision = i.image_id
+  and ci.item_id = :photo_id
+
+      </querytext>
+</fullquery>
+
+    <fullquery name="select_object_metadata">
+        <querytext>
+            select cr_items.item_id,
+                   cr_items.storage_type,
+                   cr_items.storage_area_key,
+                   cr_revisions.title
+            from  cr_items,
+                 cr_revisions
+            where cr_revisions.revision_id = :live_revision
+            and cr_items.live_revision = cr_revisions.revision_id
+        </querytext>
+    </fullquery>
+ 
+</queryset>