select
       sum(case
               when rp.product_type_id = 1 and r1.protocol_id = 2 and r2.protocol_id = 20 then 1
               else 0 end) as "Астрал отчет 4.5",
       sum(case
               when rp.product_type_id = 4 and r1.protocol_id = 2 and r2.protocol_id = 20 then 1
               else 0 end) as "1СО",
       sum(case
               when rp.product_type_id = 25 and r1.protocol_id = 2 and r2.protocol_id = 20 then 1
               else 0 end) as "НАО"
from ro_product rp
         join ro_abonent ra on rp.abonent_id = ra.abonent_id
         join ro_region rr on ra.region_id = rr.region_id
         join ro_mercury_recipient rmr1 on rp.product_id = rmr1.mercury_id
         join ro_recipient r1 on rmr1.recipient_id = r1.recipient_id
         join ro_mercury_recipient rmr2 on rp.product_id = rmr2.mercury_id
         join ro_recipient r2 on rmr2.recipient_id = r2.recipient_id
         join ro_contract rc on rp.contract_id = rc.contract_id
         join ro_contract_tariff rct on rc.contract_id = rct.contract_id
where product_type_id in (1, 4, 25)
  and rr.region_code = '39'
  and rct.end_date > current_date
  and rct.step_id = 5
  and r1.protocol_id = 2
  and r2.protocol_id = 20;