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-15T17:36:05' AND '2026-08-16T17:36:05'
    AND dateFinishOrder1 IS NOT NULL
    AND dateStartOrder2 IS NOT NULL

  ORDER BY logCompletedDate ASC<br>