SELECT ONE_Tarea__r_Name,ONE_Nombre_Y_Apellidos_Del_Difunto__c,ONE_Codigo_De_Centro__c,ONE_Lugar_De_Origen__r_Name,ONE_Lugar_De_Destino__r_Name,driverId,driverName,licensePlate,acompañantes,scheduledDate,(SELECT email FROM conductores WHERE name=jobssaleforce.driverName )AS email, (SELECT vehicleId FROM conductores WHERE name=jobssaleforce.driverName )AS vehicleId FROM `jobssaleforce` WHERE ((logAssignedDate BETWEEN '2026-08-16T17:37:34' AND '2026-08-16T17:38:34') AND ONE_Codigo_De_Centro__c IN (SELECT centro FROM selectzona WHERE dZonaOperativa IN ('Z.REMEDIOS','Z.SORIA','Z.GUADALAJARA','Z.LAS PALMAS','Z.SAN SEBASTIAN','Z.GIRONA','Z.CADIZ'))) AND (logDeassignedDate IS NULL OR logDeassignedDate BETWEEN '1000-01-01T00:00:00' AND '2026-08-16T17:37:33')<br><br>