Here Son

For my eternal fifa son
mail@pastecode.io avatar
unknown
mysql
a year ago
523 B
1
Indexable
Never
SELECT O.CustomerReference, cc.PackagingRequiredPayload 
FROM Consignments c 
LEFT JOIN PickAndPackOrders papo ON papo.ConsignmentID = c.ID
LEFT JOIN Orders o ON papo.OrderID = o.ID 
LEFT JOIN CourierCalculations cc ON cc.ID = o.CourierCalculationID 
WHERE c.ProviderID = '1164D3B4-77A2-4E21-A1FA-BB4E2B88593C'
--AND o.ID = 'E945D254-9477-4686-A47D-08DB260C57C5'
AND O.ID IN ('151c0cd4-d747-4022-70e6-08db3bdc159b', 'bd8c3442-1f5a-4e98-70e7-08db3bdc159b', '7a742382-9172-4053-70e8-08db3bdc159b')
ORDER BY c.CreatedDate DESC