JavaScript code:

let columns = {
  id: 'negotiation.id',
  // ...
};
let query = knex
  .select(columns)
  .from('negotiations as negotiation')
  .innerJoin('organizations as organization', 'negotiation.counterpartOrganizationId', 'organization.id')
  .whereExists(knex
    .select()
    .from('negotiations_properties as negotiationsProperties')
    .where('negotiationsProperties.negotiationId', '=', knex.raw('??', ['negotiation.id']))
    .where('negotiationsProperties.propertyId', '=', 5)
  )