photo-delete.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>
<queryset>

<fullquery name="get_parent_album">      
      <querytext>
      select parent_id from cr_items where item_id = :photo_id
      </querytext>
</fullquery>

 
<fullquery name="get_photo_info">      
      <querytext>
      select 
      cr.title,
      i.height as height,
      i.width as width,
      i.image_id as image_id
    from cr_items ci,
      cr_revisions cr,
      cr_items ci2,
      cr_child_rels ccr2,
      images i
    where ci.live_revision = cr.revision_id
      and ci.item_id = ccr2.parent_id
      and ccr2.child_id = ci2.item_id
      and ccr2.relation_tag = 'viewer'
      and ci2.live_revision = i.image_id
      and ci.item_id = :photo_id
     
      </querytext>
</fullquery>

 
</queryset>