SELECT xp_bulk_management.id,xp_bulk_management.order_id,xe.batchid,xp_bulk_management.service_id,xe.id as eevid,xp_bulk_management.shipping_comfirmation,xp_bulk_management.acknowledge_reciept
FROM `xp_batch_eevid` as xe inner join xp_bulk_management as xp_bulk_management
on xe.batchid=xp_bulk_management.batch_id
INNER JOIN xp_wc_orders ON xp_wc_orders.id= xp_bulk_management.order_id 
INNER join xp_postmeta ON xp_postmeta.post_id = xp_bulk_management.service_id 
where xe.sourceid='XP4569746215OR5164555' AND xp_wc_orders.type = 'shop_order'
 AND xp_wc_orders.status = 'wc-processing'
AND xp_bulk_management.xp_register_mail='1' 
group by xp_bulk_management.order_idsend