24	24	</querytext>
			25	25	</fullquery>
			26	26
			27		<fullquery name="select_params">
				27	<fullquery name="select_params">
			28	28	<querytext>
			29	29	select p.parameter_name,
			30	30	coalesce(p.description, 'No Description') as description,
			31	31	v.attr_value,
			32	32	coalesce(p.section_name, 'main') as section_name,
			33		p.datatype
				33	p.datatype,
				34	p.default_value
			34	35	from apm_parameters p left outer join
			35	36	(select v.parameter_id, v.attr_value
			36	37	from apm_parameter_values v
			37	38	where (v.package_id = :package_id or v.package_id is null)) v
			38	39	on p.parameter_id = v.parameter_id
			39	40	where p.package_key = :package_key
			40	41	and p.scope = :scope
			41		$section_where_clause
				42	$section_where_clause
			42	43	order by
			43	44	case when lower(section_name) = 'deprecated'
			44	45	then null
			48	49	</querytext>
			49	50	</fullquery>
			50	51
			51		<fullquery name="select_params_set">
				52	<fullquery name="select_params_set">
			52	53	<querytext>
			53	54	select p.parameter_name as c__parameter_name
			54	55	from apm_parameters p left outer join
			63	64	</fullquery>
			64	65
			65	66	</queryset>
			66