SELECT 
    Id
    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-07-15T07:57:43' AND '2026-08-16T07:57:43'
    AND dateFinishOrder1 IS NOT NULL
    AND dateStartOrder2 IS NOT NULL

  ORDER BY logCompletedDate ASC<br>