Index: openacs-4/packages/photo-album/www/photo.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/photo-album/www/photo.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/photo-album/www/photo.xql	18 Nov 2003 18:36:21 -0000	1.3
+++ openacs-4/packages/photo-album/www/photo.xql	3 May 2004 13:13:56 -0000	1.4
@@ -93,4 +93,23 @@
       </querytext>
 </fullquery>
 
+<fullquery name="get_thumbnail_info">      
+  <querytext>
+    select ci.item_id as thumb_photo_id,
+           i.image_id as thumb_image_id,
+           i.height as thumb_height,
+           i.width as thumb_width
+      from cr_items ci,
+           cr_items ci2,
+           cr_child_rels ccr2,
+           images i
+     where ccr2.relation_tag = 'thumb'
+       and ci.item_id = ccr2.parent_id
+       and ccr2.child_id = ci2.item_id
+       and ci2.live_revision = i.image_id
+       and ci.live_revision is not null
+       and ci.item_id = :photo_id
+     </querytext>
+</fullquery>
+
 </queryset>