-- before
SELECT OcPoiCategory.OC_POI_CATEGORY_ID,
       OcPoiCategory.NAME
FROM OC_POI_CATEGORY OcPoiCategory, V_GUI_USER_OC_POI_CATEGORY VGuiUserOcPoiCategory, oc_day_aggreg OcDayAggreg
WHERE VGuiUserOcPoiCategory.OC_POI_CATEGORY_ID = OcPoiCategory.OC_POI_CATEGORY_ID
AND OcPoiCategory.OC_POI_CATEGORY_ID = OcDayAggreg.OC_POI_CATEGORY_ID
AND OcDayAggreg.VO_PERSON_CATEGORY_ID = 100650
AND VGuiUserOcPoiCategory.GUI_USER_ID = 101114
ORDER BY 2;

-- after
SELECT OcPoiCategory.OC_POI_CATEGORY_ID,
       OcPoiCategory.NAME
FROM OC_POI_CATEGORY OcPoiCategory, V_GUI_USER_OC_POI_CATEGORY VGuiUserOcPoiCategory, oc_day_aggreg OcDayAggreg
WHERE VGuiUserOcPoiCategory.OC_POI_CATEGORY_ID = OcPoiCategory.OC_POI_CATEGORY_ID
AND OcPoiCategory.OPERATION_CENTER_ID = OcDayAggreg.OPERATION_CENTER_ID
AND OcDayAggreg.VO_PERSON_CATEGORY_ID = 100650
AND VGuiUserOcPoiCategory.GUI_USER_ID = 101114
AND ocpoicategory.is_home_poi_category = 'N'
ORDER BY 2;