Cacher is the code snippet organizer for pro developers

SELECT ContactId, [Supply Contract Id], a.Email, a.[Product End Date], [UMAX Account Number]
FROM [Supply Contracts to Contacts] a

  
WHERE
CustomerGroup__c = 'MKB'
AND Status = 'Contract actief'
AND Active = 'True'
AND [Do Not Contact Email] = 'False'
AND [Do Not Contact Mail] = 'False'
AND [Do Not Contact Phone] =  'False'
AND [Cancellation Reason] NOT LIKE '%Wanbetaler%'
AND [MC OptOuts] NOT LIKE '%actions%'
AND Intermediary NOT LIKE '%LSVW%' AND Intermediary NOT LIKE '%Hellemans%' AND Intermediary NOT LIKE '%Vrijblijvend Voorste%' AND Intermediary NOT LIKE '%NutSelect%'
AND [Bad Debtor] = 'False'
AND Deceased = 'False'
AND [Has Active Contracts] = 'True'
AND [Supply Contract End Date] = '01-01-1900'

AND [Product Start Date] > DATEADD(day, DATEDIFF(day,0,GETDATE())-91,0)