select da.archive_name from download_archives_obj da where da.archive_id = :archive_id select count(*) from download_downloads d, download_arch_revisions_obj dar where dar.archive_id = :archive_id and d.revision_id = dar.revision_id [ad_dimensional_sql $dimensional where] select count(*) from download_downloads d, download_arch_revisions_obj dar where dar.archive_id = :archive_id and d.revision_id = dar.revision_id select distinct d.user_id from download_downloads_repository d, download_arch_revisions_obj dar where d.repository_id = :repository_id and dar.archive_id = :archive_id and dar.revision_id = d.revision_id [ad_dimensional_sql $dimensional where]