Index: openacs-4/packages/photo-album/www/random-photo-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/photo-album/www/random-photo-postgresql.xql,v diff -u -N -r1.3 -r1.3.6.1 --- openacs-4/packages/photo-album/www/random-photo-postgresql.xql 1 Feb 2004 22:04:16 -0000 1.3 +++ openacs-4/packages/photo-album/www/random-photo-postgresql.xql 19 Jan 2006 03:50:27 -0000 1.3.6.1 @@ -49,7 +49,7 @@ i.height as thumb_height, i.width as thumb_width, random() as seed - from cr_items ci, cr_items ci2, ci_items root, cr_child_rels ccr2, images i + from cr_items ci, cr_items ci2, cr_items root, cr_child_rels ccr2, images i where $size_clause and ci.item_id = ccr2.parent_id and ccr2.child_id = ci2.item_id