SELECT id,ONE_Nombre_Y_Apellidos_Del_Difunto__c,provider,isInterna,ONE_ID_Tarea_Frotcom__c,ONE_Estado__c,logAssignedDate,logUpdatedDate,scheduledDate,licensePlate,driverName,driverId,acompañantes,(SELECT vehicleIdWFM FROM `conductores` WHERE id = jobssaleforce.driverId) as vehicleIdWFM FROM `jobssaleforce` WHERE updateChanges='1' AND ONE_Estado__c in ('Pendiente de aceptar','Aceptado','Programado') AND scheduledDate BETWEEN '2026-08-16T17:06:38' AND '2026-08-16T18:06:38'<br>