/* CabinetContracts - ContractsView */

Select c.id_contract
      ,ps.name_Kind_paragraph
      ,ps.Status_Text
      ,c.d_start
      ,c.d_end
      ,c.dp_end
From web_user_wp wu
    ,employees_  e
    ,contracts_  c
    ,paragraphs_status_ ps
Where
    wu.id_web_user = :Bind_IdWebUser
    and wu.id_e_kis = e.id_e
    and e.id_contractor = c.id_with_whom
    and c.id_paragraph = ps.id_paragraph

Order by c.d_start desc, ps.name_Kind_paragraph, ps.Status_Text