SELECT v.vehicle_id,
  v.numberplate,
  v.company_nr,
  v.brand,
  v.model
FROM gu_vehicle gv,
  vehicle_data vd,
  vehicle v
WHERE gv.vehicle_id = vd.vehicle_id
AND vd.vehicle_id   = v.vehicle_id
AND gv.gui_user_id  = 101712
AND vd.gps_full_date BETWEEN toutcdate(to_date('01/01/2020 00:00:00','dd/MM/yyyy HH24:MI:SS'), 'Europe/Brussels') AND toutcdate(to_date('02/01/2020 23:59:59','dd/MM/yyyy HH24:MI:SS'),'Europe/Brussels')
AND MDSYS.SDO_GEOM.SDO_DISTANCE (mdsys.sdo_geometry(2001,8307, mdsys.sdo_point_type(NVL(vd.wgs84_longitude,0), NVL(vd.wgs84_latitude,0), NULL), NULL, NULL),mdsys.sdo_geometry(2001,8307, mdsys.sdo_point_type(4.277140, 50.766240, NULL), NULL, NULL), 0.0001) < ( 5000 );


-- original 01/01/2020 20/05/2020