select email from parties where user_id = [ad_get_user_id] select v.package_key, v.version_id, v.package_name, v.version_name from apm_package_version_info v, apm_package_owners o where o.owner_url = :email and v.version_id = o.version_id and v.installed_p = 't' order by upper(package_name) select path from apm_package_files where version_id = :version_id