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 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