select skuId from tbl_PRD_SKus where ownerId = and fsl_tablecode = 'MFR' select s.subscriberId, s.subscriberType, dp.dataProviderId from tbl_PRD_Subscriptions s inner join tbl_PRD_DataProviders dp on dp.dataOwnerId = s.ownerId and dp.dataOwnerType = s.ownerType and dp.ownerType = s.subscriberType where s.ownerId = and s.ownerType = 'MFR' and s.subscriptionId in ( ) and s.subscriberType = 'BRO' union select s.subscriberId, s.subscriberType, dp.dataProviderId from tbl_PRD_Subscriptions s inner join tbl_PRD_DataProviders dp on dp.dataOwnerId = s.ownerId and dp.dataOwnerType = s.ownerType and dp.ownerType = s.subscriberType where s.ownerId = and s.ownerType = 'MFR' and s.subscriberType = 'CHO' and s.subscriptionId in ( ) union select s.subscriberId, s.subscriberType, dp.dataProviderId from tbl_PRD_Subscriptions s left outer join tbl_PRD_DataProviders dp on dp.dataOwnerId = s.ownerId and dp.dataOwnerType = s.ownerType and dp.ownerType = s.subscriberType where s.ownerId = and s.ownerType = 'MFR' and s.subscriberType = 'MFR' and s.subscriptionId in ( )

Batch #_key# #_batchCount# #listLen( _skuIds )# #_skuIds#