Apr 15th, 2021
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT VGuiUserOcPoi.poi_id,  vpc.vo_person_category_id,, VGuiUserOcPoi.short_name
  2.  FROM V_GUI_USER_OC_POI  VGuiUserOcPoi, vo_person_category vpc
  3. WHERE
  4.  VGuiUserOcPoi.oc_poi_category_id = vpc.hiring_p_oc_poi_category_id
  5. AND VGuiUserOcPoi.OC_POI_STATUS_ID IN (0,3)
  6. AND (VGuiUserOcPoi.gui_user_id = ?)
  7. ORDER BY name
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add to your ad blocker whitelist or disable your adblocking software.