SELECT c.id,c.Consent_Level_Summary__c,c.AMC_Status__c,c.CreatedDate,c.LastModifiedDate, c.AMC_Last_Activity_Record_ID__c FROM ENT.Contact_Salesforce_1 as c INNER JOIN Mining_opt_outs t ON c.id = t.SF_ID WHERE CONSENT_LEVEL_SUMMARY__C <> 'Revoked Consent'