| SQL |
SELECT s.skuId, s.sku, s.skuDesc, s.packSizeDesc, s.samplepackSizeDescSA,
p.MASTER_UNIT_SIZE_DESC, p.MASTER_UNIT_SIZE, p.MASTER_UNIT_SIZE_MEASURE
FROM tbl_PRD_SKUs s with (nolock)
left outer join tbl_PRD_Packaging p with (nolock)
on p.ownerId = s.ownerId
and p.fsl_tablecode = s.fsl_tablecode
and p.linkType = 'SKU'
and p.linkId = s.skuId
WHERE s.OwnerID = 4839
AND s.FSL_TableCode = 'MFR'
AND s.inactive = '0'
AND s.discontinued = 'N'
AND s.sampleEligible = 'Y'
AND (s.unpublishDate >= {d '2026-04-17'}
AND {d '2026-04-17'} >= s.publishdate)
AND s.sku = '70850401R ' |