select rapart.full_name as "Партнёр",
       rapart.inn,
       rapart.kpp,
       rac.full_name,
       rac.inn,
       rac.kpp,
       rac.phone,
       rac.email,
       rab.full_name as "Абонент АЦ",
       rab.inn,
       rab.kpp,
       rab.phone,
       rab.email
from ro_product rp
join ro_office ro on rp.office_id = ro.office_id
join ro_agent ra on ro.agent_id = ra.agent_id
join ro_abonent rapart on ra.abonent_id = rapart.abonent_id
join ro_abonent rab on rp.abonent_id = rab.abonent_id
join ro_contract rc on rp.contract_id = rc.contract_id
join ro_contract_tariff rct on rc.contract_id = rct.contract_id
join ro_price_tariff rpt on rct.tariff_id = rpt.tariff_id
join ro_abonent rac on rp.accr_represent_id = rac.abonent_id
where rp.product_type_id = 1 and rpt.tariff_id in (216,248,300) and rp.accr_represent = true;