oracle8.1.6
select da.archive_id,
dat.pretty_name as archive_type,
da.archive_type_id,
da.archive_name,
da.summary,
da.description,
da.description_type,
dar.revision_id,
dar.file_name,
dar.version_name,
dar.version_name,
round(dbms_lob.getlength(dar.content) / 1024) as file_size,
(select count(*) from download_downloads where revision_id = dar.revision_id) as downloads,
dar.approved_p,
u.last_name || ', ' || u.first_names as creation_user_name,
dar.creation_user,
dar.creation_date
$metadata_selects
from download_archives_obj da,
download_archive_types dat,
download_arch_revisions_obj dar,
cc_users u
where da.repository_id = :repository_id and
dat.archive_type_id = da.archive_type_id and
da.archive_id = dar.archive_id and
dar.revision_id = :revision_id and
dar.creation_user = u.user_id