enivar SMS en tareas de recogida

<h1>enivar SMS en tareas de recogida</h1><br><br><br><br><h1>enivar SMS en tareas de traslado</h1><br><br>SELECT DISTINCT 
  ONE_Expediente__r_Name,
  driverId,
  driverName,
  acompañantes,
  idVehicle,
  licensePlate,
  ONE_Tarea__r_Name,
  ONE_Nombre_Y_Apellidos_Del_Difunto__c,
  isInterna,
  scheduledDate,
  ONE_Codigo_De_Centro__c 
FROM `jobssaleforce` WHERE acompañantes IS NOT NULL AND acompañantes != '' AND  isInterna IS NULL AND ONE_Tipo_De_Traslado__c != 'Recogida' AND sendSMS IS NULL AND scheduledDate BETWEEN '2000-01-01T00:00:00' AND '2026-08-16T08:30:25'<br><br><h1>enivar SMS en tareas internas</h1><br><br>SELECT 
  Id,
  driverId,
  driverName,
  acompañantes,
  idVehicle,
  licensePlate,
  ONE_Tarea__r_Name,
  ONE_Nombre_Y_Apellidos_Del_Difunto__c,
  isInterna,
  scheduledDate,
  ONE_Codigo_De_Centro__c 
FROM `jobssaleforce` WHERE acompañantes IS NOT NULL AND acompañantes != '' AND  isInterna = '1' AND sendSMS IS NULL AND scheduledDate BETWEEN  '2000-01-01T00:00:00' AND '2026-08-16T08:30:25'