select top 10 scc14 from tbl_PRD_Skus s inner join tbl_PRD_Packaging p on s.skuid = p.linkId and p.linkType = 'SKU' where s.ownerid = 1657 and s.fsl_TableCode = 'MFR' and skuType = 'EA' --and sku = '8900061' and month(gs1_syncDate) = 8 and day(gs1_syncDate) = 8 and year(gs1_syncDate) = 2018 and len(sku) < 14 order by gs1_syncDate desc