USE posilator
GO

SELECT ip.id AS 'IncomingParcelID'
,       epo.id AS 'ExpectedOrderID'
,       o.id AS 'OrderID'
,       ser.id AS 'ServiceID'
,       ser.name AS 'ServiceName'
 FROM psl_expectedParcelOrders epo
JOIN psl_orders o ON o.expectedParcelOrderID = epo.id
JOIN psl_incomingParcels ip ON ip.orderID = epo.id
LEFT JOIN  psl_service_incomingParcels sip ON sip.incomingParcelID = ip.id
LEFT JOIN   psl_services ser ON ser.id = sip.serviceID
WHERE epo.id = 88

-- OR --

SELECT ip.id AS 'IncomingParcelID'
,       epo.id AS 'ExpectedOrderID'
,       o.id AS 'OrderID'
,       ser.ServiceID AS 'ServiceID'
,       ser.ServiceName AS 'ServiceName'
,       ser.ID      AS 'In/Out ParcelID'
,       ser.IsIncoming AS 'IsIncoming'
 FROM psl_expectedParcelOrders epo
JOIN psl_orders o ON o.expectedParcelOrderID = epo.id
JOIN psl_incomingParcels ip ON ip.orderID = epo.id
LEFT JOIN vw_psl_parcelServices ser ON (ser.ID = ip.id AND ser.IsIncoming = 1)
WHERE epo.id = 88