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]