SELECT distinct o.mfrId, m.mfr_Name FROM tbl_CDR_Orders O inner join tblManufacturers m on m.mfr_id = o.mfrId INNER JOIN tbl_PRD_SKUs S ON S.OwnerId = O.OwnerId AND S.FSL_TableCode = O.OwnerType AND S.sku = O.MfrSku WHERE O.OwnerId = AND O.OwnerType = AND O.Stocked = 'Y' AND O.distributorId = AND datediff( d, O.orderDate, GETDATE() ) <= 30 and o.mfrId not in ( select p.mfrId from tbl_BRO_Principals p inner join tbl_BRO_PrincipalTerritories pt on pt.principalId = p.principalId and pt.ownerId = p.ownerId and pt.ownerType = pt.ownerType inner join tbl_BRO_PrincipalDistributors pd on pd.principalTerritoryId = pt.principalTerritoryId and pd.ownerId = pt.ownerId and pd.ownerType = pt.ownerType where pd.cdrRecordId = and pd.ownerType = and pd.ownerId = ) insert into tbl_BRO_PrincipalDistributors ( ownerId, ownerType, principalTerritoryId, cdrRecordID ) values ( , , , )