---

SELECT
    cast(aibd.accepted as date) as br_date,
    count(*) as cnt
FROM ourpension.ops_pension_assignment_application opaa

left join ourpension.payment_type pt
    on opaa.payment_way = pt.code

join ourpension.sharer s
    on s.id = opaa.sharer_id

join ourpension.contract c
    on c.id = s.contract_id

join ourpension.individual i
    on i.id = c.individual_id

join ourpension.address a
    on i.registration_address_id = a.id

left join ourpension.decision_payment_type dpt
    on opaa.decision_payment_type_code = dpt.code

left join ourpension.application_individual_bank_detail aibd
    on opaa.bank_detail_id = aibd.id

where opaa.ops_payment_type_code = '05'
  and aibd.accepted is not null
  and opaa.appeal_date <= current_date

group by cast(aibd.accepted as date)

order by br_date desc

limit 50;