select first_names, last_name, email from persons, parties where person_id = :user_id and person_id = party_id select apm_parameter_values.attr_value from apm_parameters, apm_parameter_values where apm_parameter_values.package_id is null and apm_parameter_values.parameter_id = apm_parameters.parameter_id and apm_parameters.parameter_name = :parameter_name select apm_parameter_values.attr_value from apm_parameters, apm_parameter_values where apm_parameter_values.package_id = :key and apm_parameter_values.parameter_id = apm_parameters.parameter_id and apm_parameters.parameter_name = :parameter_name select v.package_id, p.parameter_name, v.attr_value from apm_parameters p, apm_parameter_values v where p.parameter_id = v.parameter_id