select p.*, pr.NUMBER_IN as NUMBER_IN_PR, c.EXECUTE_BEGIN as EXECUTE_BEGIN_C, c.EXECUTE_END as EXECUTE_END_C, 
  c.CLIENT_ID as CLIENT_ID_C, c.PDV as PDV_C, c.PDV_WITHOUT as PDV_WITHOUT_C, c.PDV_TOTAL as PDV_TOTAL_C, 
  c.FIRST_PART_NUMBER_CONTRACT as FIRST_PART_NUMBER_CONTRACT_C,
  c.CREATE_NUMBER as CREATE_NUMBER_C 
    from PLAN_D p 
    join CONTRACT c on p.CONTRACT_ID = c.ID 
    join PROPOSAL pr on pr.ID = c.PROPOSAL_ID 
      where c.SEND_STATUS = 1 and p.ARCHIVE = 1 
        order by p.ID

select d.PROPOSAL_ID,
  list(distinct(sw.NAME_SORT_WORK), ', ') as SORT_WORK_LIST,
  list(distinct(c.DEPARTMENT_ID_EXECUTE), ', ') as DEPARTMENT_EXECUTE
    from DEVICES d
    join SORT_WORK sw on d.SORT_WORK_ID = sw.ID
    join CONTRACT c on c.PROPOSAL_ID = d.PROPOSAL_ID
      where d.PROPOSAL_ID = 1
         group by  d.PROPOSAL_ID