---

select
    s.id as sharer_id,
    s.number,
    count(p.id) as payment_count,
    max(p.completed) as last_execution_date
from ourpension.sharer s
left join back_office.payment p
    on p.sharer_id = s.id
where s.number like '%02688346889'
   or s.number like '%01186988977'
group by s.id, s.number
order by s.number;