select skuId from tbl_PRD_SKus with (nolock) where ownerId = 288 and fsl_tablecode = 'MFR' and gs1_syncDate is null and not exists ( select * from tbl_TPM_RequestProducts p with (nolock) where p.catalogId = skuId and p.catalogType = 'SKU' and p.ownerId = 288 and p.ownerType = 'MFR' )