SELECT DISTINCT p.*, vpc.vo_person_category_id, vpc.name, pd.event_date, vo.company_name,
COALESCE(vpc.company_tin, vo.company_tin), ocal.oc_calendar_id,
COALESCE(p.oc_calendar_id, vpc.oc_calendar_id, vo.oc_calendar_id) "Inherited calendar",
COALESCE(p.working_schedule_id, vpc.working_schedule_id), gu.loginname, gu.loginpwd
FROM person p, vo_person_category vpc, person_data pd, vehicle_owner vo, oc_calendar ocal, operation_center oc1, operation_center oc2, admin_center ad, admin_center adc, working_schedule ws, gui_users gu, gu_person gp
WHERE ad.admin_center_id=vo.admin_center_id
AND adc.admin_center_id=oc1.admin_center_id
AND oc1.operation_center_id=ocal.operation_center_id
AND oc2.operation_center_id=gu.operation_center_id
AND gu.gui_user_id=gp.gui_user_id
AND vo.vehicle_owner_id=vpc.vehicle_owner_id
AND vpc.vo_person_category_id=p.vo_person_category_id
AND p.person_id=pd.person_id
AND p.working_schedule_id=ws.working_schedule_id;