---

SELECT 
    arap.id,
    arap.status_id,
    arap.created_manually,
    arap.accrual_type_code,
    COUNT(d.id) as details_count,
    COUNT(p.id) as payment_count,
    MIN(p.payment_register_id) as register_id
FROM back_office.accrual_repurchase_amount_payments arap
LEFT JOIN back_office.accrual_repurchase_amount_payments_details d 
    ON d.accrual_repurchase_amount_payments_id = arap.id
LEFT JOIN back_office.payment p 
    ON p.accrual_repurchase_id = d.id
WHERE arap.id = 176
GROUP BY arap.id, arap.status_id, arap.created_manually, arap.accrual_type_code;