with my_designators as (
	select distinct designator, ordertype from shipped_orders
	where (ordertype like '%Sales%' or ordertype like '%Lease%' or ordertype like '%Loan%')
	UNION
	select distinct designator, ordertype from orders
	where (ordertype like '%Sales%' or ordertype like '%Lease%' or ordertype like '%Loan%')
	order by 1
)
select
designator,
description,
continent,
ordertype,
(
	select string_agg(ordertype, '~') from (
		select distinct ordertype
		from my_designators
		where designator = ANY(string_to_array(designators.designator, '/'))
	)tmp
)
from designators
where enabled = 't'