SELECT 
    id,
    ONE_Longitud_Y_Latitud_Origen__Latitude__s,
    ONE_Longitud_Y_Latitud_Origen__Longitude__s,
    licensePlate,
    scheduledDate,
    visitsToCoordinatesRequestId,
    dateStartInProgress,
    dateFinishOrder1,
    dateStartOrder2,
    dateFinishOrder2
FROM jobssaleforcecompleted
WHERE ONE_Tipo_De_Traslado__c = 'Recogida'
  AND ONE_Longitud_Y_Latitud_Origen__Latitude__s != ''
  AND ONE_Longitud_Y_Latitud_Origen__Longitude__s != ''
  AND logCompletedDate BETWEEN '2026-08-06T17:37:25' AND '2026-08-16T17:37:25'
  AND (visitsToCoordinatesRequestId != 'No hemos encontrado visita al lugar' OR visitsToCoordinatesRequestId IS NULL)
  AND dateStartInProgress IS NOT NULL
  AND dateFinishOrder2 IS NOT NULL
  AND (
        (dateFinishOrder1 IS NULL OR dateFinishOrder1 IN ('', '-'))
    AND (dateStartOrder2 IS NULL OR dateStartOrder2 IN ('', '-'))
  )
  ORDER BY logCompletedDate ASC
  LIMIT 30<br>No hay tareas en progreso<br>