Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT "ausp".id,
- "ausp".set_date,
- "ausp".usr,
- "ausp".staff,
- "ausp".standing_penalty,
- "ausp".org_unit,
- "ausp".stop_date,
- "ausp".note
- FROM actor.usr_standing_penalty AS "ausp"
- LEFT JOIN config.standing_penalty AS "__standing_penalty.block_list_csp" ON ( "__standing_penalty.block_list_csp".id = "ausp".standing_penalty )
- LEFT JOIN actor.org_unit AS "__org_unit.shortname_aou" ON ( "__org_unit.shortname_aou".id = "ausp".org_unit )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement