Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 = ? -- current person category that you are editting
- AND VGuiUserOcPoiCategory.GUI_USER_ID = ? -- current user
- ORDER BY 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement