select distinct VacancyInternalID
	,VacancyTitle
	,null ParentInternalID
	,null GeoLocation
	,
order = (
		case @SortFieldIndexConfig
			when 2
				then VacancyTitle
			else VacancyInternalID
		end
		)
from Vacancy.TB_Vacancy va
inner join Config.TB_Contract co on va.VacancyContractID = co.ContractInternalID
where co.ContractExternalID = '492A94D0-7D71-46E5-A8F6-E3A973394647'
	and co.ContractStatusID = 1
	and VacancyStatusID = 1
	and VacancyTitle like '%%'
order by (
		case @SortFieldIndexConfig
			when 2
				then VacancyTitle
			else VacancyInternalID
			end
		) desc

select distinct VacancyInternalID
	,VacancyTitle
	,null ParentInternalID
	,null GeoLocation
	,
OrderBy = (
		case @SortFieldIndexConfig
			when 2
				then VacancyTitle
			else VacancyInternalID
		end
		)
from Vacancy.TB_Vacancy va
inner join Config.TB_Contract co on va.VacancyContractID = co.ContractInternalID
where co.ContractExternalID = '492A94D0-7D71-46E5-A8F6-E3A973394647'
	and co.ContractStatusID = 1
	and VacancyStatusID = 1
	and VacancyTitle like '%%'
order by (
		case @SortFieldIndexConfig
			when 2
				then VacancyTitle
			else VacancyInternalID
			end
		) desc

SELECT 
	 sub.VacancyInternalID
	,sub.VacancyTitle
	,sub.ParentInternalID
	,sub.GeoLocation	
FROM
	(
	select distinct VacancyInternalID
		,VacancyTitle
		,null ParentInternalID
		,null GeoLocation
		,OrderBy1= (
			case @SortFieldIndexConfig
				when 1	then VacancyInternalID
				when 2	then VacancyTitle
				else VacancyInternalID
			end
			)
		,OrderBy2= (
			case @SortFieldIndexConfig
				when 1	then VacancyInternalID
				when 2	then VacancyTitle
				else VacancyInternalID
			end
			)
	from Vacancy.TB_Vacancy va
	inner join Config.TB_Contract co on va.VacancyContractID = co.ContractInternalID
	where co.ContractExternalID = '492A94D0-7D71-46E5-A8F6-E3A973394647'
		and co.ContractStatusID = 1
		and VacancyStatusID = 1
		and VacancyTitle like '%%'
	) sub 
ORDER BY sub.OrderBy1 DESC, sub.OrderBy2 DESC