SELECT VoGroup.VO_GROUP_ID,
       VoGroup.VEHICLE_OWNER_ID,
       VoGroup.NAME,
       VoGroup.GRAPHICAL_SYMBOL,
       VoGroup.LM_COMMENT,
       VoGroup.PARENT_VO_GROUP_ID,
       VoGroup.COMPANY_NR
FROM VO_GROUP VoGroup
WHERE VoGroup.PARENT_VO_GROUP_ID IS NULL
AND (VoGroup.VO_GROUP_ID IN (SELECT DISTINCT vo_group.parent_vo_group_id FROM vo_group, vo_group_person, gu_person
WHERE vo_group.vo_group_id = vo_group_person.vo_group_id
AND gu_person.person_id = vo_group_person.person_id
AND gu_person.gui_user_id=?) OR VoGroup.VO_GROUP_ID IN (SELECT DISTINCT vo_group.parent_vo_group_id FROM vo_group, vo_group_vehicle, gu_vehicle
WHERE vo_group.vo_group_id = vo_group_vehicle.vo_group_id
AND gu_vehicle.vehicle_id = vo_group_vehicle.vehicle_id
AND gu_vehicle.gui_user_id=?))