select count(*) as gc_mounted_p from site_nodes sn, apm_packages ap where ap.package_key = 'general-comments' and sn.object_id = ap.package_id select count(*) as workflow_mounted_p from site_nodes sn, apm_packages ap where ap.package_key = 'acs-workflow' and sn.object_id = ap.package_id select default_value from apm_parameters where package_key = 'acs-kernel' and parameter_name='SystemURL' select email as good_email from parties where party_id = :notification_sender