Blog

Blog » 2019 » December » 17 » Contact Extract
00:22
Contact Extract

FROM Contact WHERE Brand_Name__c = 'Etude' AND RecordTypeId = '012E000000066VlIAI'

Select AccountId, Id, Brand_Name__c , FirstName, LastName, Company__c, Email, Phone, MobilePhone, HomePhone, OtherPhone, Phone_1__c, Phone_2__c, SMS_phone__c, Birthdate, HasOptedOutOfEmail, IsEmailBounced, Email_Actionable__c, Total_Order_Value__c, Last_Order_Date__c, Active_Club_Memberships__c FROM Contact where RecordTypeId = '012E000000066VlIAI' AND (Brand_Name__c = 'Beringer' OR Brand_Name__c = 'Stags Leap' OR Brand_Name__c = 'BV' OR Brand_Name__c = 'Sterling' OR Brand_Name__c = 'Chateau St. Jean' OR Brand_Name__c = 'Provenance Vineyards' OR Brand_Name__c = 'Hewitt')

FROM Club_Member__c WHERE Brand__c = 'Etude' AND Club_Membership_Status__c = 'Active' LIMIT 1