SELECT o.ID, fn.meta_value as first_name, ln.meta_value as last_name,
SUBSTRING_INDEX(SUBSTRING_INDEX(t.meta_value,';',9),':',-1) AS tracking
FROM `wp_posts` o
JOIN `wp_postmeta` t ON t.post_id = o.ID
JOIN `wp_postmeta` fn ON fn.post_id = o.ID
JOIN `wp_postmeta` ln ON ln.post_id = o.ID
WHERE
o.`post_type` = 'shop_order'
AND
t.`meta_key` = '_wc_shipment_tracking_items'
AND
fn.`meta_key` = '_shipping_first_name'
AND
ln.`meta_key` = '_shipping_last_name';