select id, OCC_Salesperson_Name__c, OCC_Salesperson_Id__c, OCC_Event_Type__c, OCC_Customer__r.OCC_Contact_Country__c, OCC_Customer__r.OCC_PreferredLanguage__c, OCC_Customer__r.Email, OCC_Customer__r.MobilePhone, OCC_Customer__r.Name, OCC_Store__r.OCC_TPVID__c, OCC_AppointmentDate__c, OCC_Customer__r.OCC_CustomerExternalID__c FROM OCC_Appointment__c WHERE (OCC_Event_Type__c = '1' OR OCC_Event_Type__c = '2' ) AND OCC_Status__c = 'TR' AND OCC_Customer__r.Email != null AND OCC_Customer__r.OCC_Contact_Country__c != null AND OCC_Appointment_canceled__c = FALSE AND OCC_Not_presented__c = FALSE AND OCC_Salesperson_Id__c != '9999' AND OCC_Store__r.OCC_Aplica_Subscripcion__c = TRUE AND OCC_AppointmentDate__c = YESTERDAY