get_results($wpdb->prepare(
"SELECT p.ID, p.post_date, pm.meta_value as order_total, pm2.meta_value as order_status
FROM {$wpdb->posts} p
LEFT JOIN {$wpdb->postmeta} pm ON p.ID = pm.post_id AND pm.meta_key = '_order_total'
LEFT JOIN {$wpdb->postmeta} pm2 ON p.ID = pm2.post_id AND pm2.meta_key = '_order_status'
LEFT JOIN {$wpdb->postmeta} pm3 ON p.ID = pm3.post_id AND pm3.meta_key = '_yoone_subscription_id'
WHERE p.post_type = 'shop_order' AND pm3.meta_value = %d
ORDER BY p.post_date DESC",
$subscription->id
));
?>