postgresql7.1 select da.archive_id, da.repository_id as repository_id, da.archive_name, da.summary, dar.revision_id, dar.file_name, dar.version_name, dar.file_size / 1024 as file_size from download_archives_obj da, download_arch_revisions_obj dar where da.archive_id = dar.archive_id and dar.revision_id = :revision_id $approval