SELECT
mst.EmailAddress, ot.Identifier__c, ot.Identifier_Group__c, ot.contact_ID__c, mst.SubscriberKey, mst.Consent_Level_Summary__c, mst.FirstName, mst.LastName, mst.CreatedDate, 
mst.Mailing_Country__c, mst.Region, mst.SegmentRegion, mst.Job_Role__c, RecordTypeId


FROM ep_mr_en_us_w170049_MASTER mst
JOIN ent.Contact_Salesforce_1 c ON LOWER(c.Email) = LOWER(mst.EmailAddress)
JOIN ent.Contact_Identifier__c_Salesforce_1 ot ON mst.SubscriberKey = ot.contact_ID__c


WHERE ot.Identifier_Group__c =  'OTPreferenceCentreLink'
AND c.RecordTypeId = '0121G0000005wgHQAQ'