USE [PROD];

SELECT DISTINCT
    [m].[MERCHANT_ID]
  , [m].[MERCHANT_NAME]
  , [ms].[XMLConfiguration]
FROM [dbo].[MerchantSetup] AS [ms] WITH (NOLOCK)
LEFT JOIN [dbo].[Merchants] AS [m] WITH (NOLOCK) ON [m].[Id] = [ms].[MerchantId]
WHERE ([ms].[XMLConfiguration] LIKE '%FilterBanks%Remove ID=%FilterBanks%DirectConfiguration%DirectConfiguration%'
      OR [ms].[XMLConfiguration] LIKE '%DirectConfiguration%FilterBanks%Remove ID=%FilterBanks%DirectConfiguration%')
	  AND [ms].[XMLConfiguration] NOT LIKE '%FilterBanks%Add ID="*"%FilterBanks%';



-- ToDo this for Countries and Banks

USE [PROD];

SELECT DISTINCT
    [m].[MERCHANT_ID]
  , [m].[MERCHANT_NAME]
  , [ms].[XMLConfiguration]
FROM [dbo].[MerchantSetup] AS [ms] WITH (NOLOCK)
LEFT JOIN [dbo].[Merchants] AS [m] WITH (NOLOCK) ON [m].[Id] = [ms].[MerchantId]
WHERE ([ms].[XMLConfiguration] LIKE '%FilterCountries%Remove ID=%FilterCountries%DirectConfiguration%DirectConfiguration%'
      OR [ms].[XMLConfiguration] LIKE '%DirectConfiguration%FilterCountries%Remove ID=%FilterCountries%DirectConfiguration%')
	  AND [ms].[XMLConfiguration] NOT LIKE '%FilterCountries%Add ID="*"%FilterCountries%';