select package_key, pretty_name as pretty_name from apm_package_types order by upper(pretty_name), pretty_name select count(*) as global_params from apm_parameters where package_key = :package_key and scope = 'global'