SELECT DISTINCT order_item_name
FROM wp_woocommerce_order_items
JOIN wp_woocommerce_order_itemmeta ON wp_woocommerce_order_itemmeta.order_item_id = wp_woocommerce_order_items.order_item_id
WHERE order_id = 45246
ORDER BY wp_woocommerce_order_itemmeta.meta_key;