select
    partner_id,
    partner_name,
    standardized_name,
    country,
    currency,
    client_category,
    client_sub_category,
    purchased_services
from datawarehouse.dim_partner
where partner_id in (896,1325,1342,123,946,888,46,892)
order by standardized_name asc