SELECT p.id AS partner_id,
       p.name AS partner_name,
       uw.email AS salesman_email,
       uw.name AS salesman_name
FROM partners_delivery pd
INNER JOIN partners p ON p.id = pd.partner
INNER JOIN users_work uw ON p.salesman_id = uw.user
INNER JOIN carts_delivery cd ON cd.partner_delivery = pd.id
INNER JOIN order_delivery_goods_3rd odg ON odg.delivery = cd.id
WHERE pd.delivery = 13
AND odg.status IN (1,2,3)
GROUP BY partner_id,
         partner_name,
         salesman_email,
         salesman_name
ORDER BY salesman_id,
         partner_name