SELECT p.ID
FROM wp_posts as p
LEFT JOIN wp_woocommerce_order_items as oi
ON p.ID = oi.order_id
LEFT JOIN wp_woocommerce_order_itemmeta as oim
ON oim.order_item_id = oi.order_item_id
WHERE 1=1
AND p.post_type = 'shop_order'
AND ((p.post_status = 'wc-processing'))
AND oi.order_item_type = 'shipping'
AND oim.meta_key = 'method_id'
AND oim.meta_value = 'shipping_nova_poshta_for_woocommerce'
ORDER BY p.post_date DESC
LIMIT 0, 10