select description from cr_folders where folder_id = :folder_id
select
ci.item_id
from cr_items ci,
cr_child_rels ccr
where ci.latest_revision is not null
and ci.content_type = 'pa_photo'
and ccr.parent_id = :album_id
and ci.item_id = ccr.child_id
order by ccr.order_n
select
ceil(count(*) / [parameter::get -parameter ThumbnailsPerPage])
from
($sql)
SELECT ccr.relation_tag, image_items.name, image_items.live_revision, image_items.latest_revision, i.*, image_revs.content, image_revs.content_length
FROM cr_items photo,
cr_items image_items,
cr_revisions image_revs,
cr_child_rels ccr,
images i
WHERE ccr.parent_id = photo.item_id
and image_items.item_id = ccr.child_id
and image_items.live_revision = i.image_id
and image_revs.revision_id = image_items.live_revision
and photo.item_id = :photo_id
UPDATE pa_photos
SET camera_model = :tmp_exif_Cameramodel,
user_filename = :upload_name,
date_taken = to_timestamp(:tmp_exif_DateTime,'YYYY-MM-DD HH24:MI:SS'),
flash = :tmp_exif_Flashused,
aperture = :tmp_exif_Aperture,
metering = :tmp_exif_MeteringMode,
focal_length = :tmp_exif_Focallength,
exposure_time = :tmp_exif_Exposuretime,
focus_distance = :tmp_exif_FocusDist,
sha256 = :base_sha256
WHERE pa_photo_id = :photo_rev_id
select i.image_id, crr.content as filename, i.width, i.height
from cr_items cri, cr_revisions crr, images i
where cri.parent_id = :id
and crr.revision_id = cri.latest_revision
and i.image_id = cri.latest_revision
order by crr.content_length desc