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