select
    OPERATION_CENTER_ID,
    GUI_USER_ID,
    PERSON_ID,
    PERSON_DATA_ID,
    om_short_name,
    om_name,
    om_color,
    VEHICLE_DATA_ID,
    EVENT_DATE,
    EVENT_DATE_STR,
    EVENT_TYPE_HARD,
    EVENT_NAME,
    VEHICLE_ID,
    FIXED_UNIT_ID,
    VEHICLE_NAME,
    GRAPHICAL_SYMBOL,
    EVENT_TYPE,
    aggreg_event_type,
    aggreg_graphical_symbol,
    TOTAL_KM,
    TOTAL_HR,
    VEHICLE_DATA_RG_ADRESS,
    VEHICLE_DATA_SPEED,
    POI_NAME,
    POI_ID_LIST,
    WGS84_LATITUDE,
    WGS84_LONGITUDE,
    COMMENTS,
    pass_person_id,
    pass_last_name,
    pass_first_name,
    pass_poi_id,
    pass_home_wgs84_latitude,
    pass_home_wgs84_longitude,
    vehicle_numberplate,
    vehicle_company_nr,
    person_mframe_status,
    GRAPHICAL_SYMBOL_MFRAME,
    ref_number,
    event_type_id
 from V_ADF_PERSON_PD_HISTORY
    where PERSON_ID = 206310
    and gui_user_id=107358
    and ((7 is null and EVENT_DATE > TRUNC(SYSDATE) and EVENT_DATE < TRUNC(SYSDATE+1)) or (EVENT_DATE >= TOUTCDATE(sysdate-11,'Europe/Brussels') and EVENT_DATE <= TOUTCDATE(sysdate-5,'Europe/Brussels')))
and ('true' != 'true' or AGGREG_EVENT_TYPE is not null)
ORDER BY event_date asc, person_data_id asc;