Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement