---

SELECT
    oad.id AS decision_id,
    oad.number AS decision_number,
    oad.date AS decision_date,
    c.number AS contract_number,
    sh.id AS sharer_id
FROM back_office.ops_assignee_decision oad
JOIN ourpension.ops_assignee_payment oap
  ON oap.id = oad.ops_assignee_payment_id
JOIN ourpension.sharer sh
  ON sh.id = oap.sharer_id
JOIN ourpension.contract c
  ON c.id = sh.contract_id
JOIN ourpension.individual im
  ON im.id = sh.individual_id
JOIN ourpension.individual ip
  ON ip.id = oap.assignee_id
JOIN ourpension.agent a
  ON a.id = oad.agent_id
WHERE oad.accepted IS NOT NULL
  AND NOT EXISTS (
      SELECT 1
      FROM back_office.ops_assignee_decision_payment oadp
      WHERE oadp.ops_assignee_decision_id = oad.id
  )
ORDER BY oad.id DESC
LIMIT 20;