SELECT 
  m.col_passangers_buisnes
FROM 
  public.ticket t 

  LEFT JOIN flight f on t.flight_id = f.id
  LEFT JOIN plane p on f.plane_id = p.id
  LEFT JOIN model_plane m on p.model_plane_id = m.id

WHERE 
  t.id = 1

	public Integer getColPassBuisnes() {
		EntityManager em = getEntityManager();
		CriteriaBuilder cb = em.getCriteriaBuilder();
		CriteriaQuery<Integer> cq = cb.createQuery(Integer.class);
		Root<Ticket> from = cq.from(Ticket.class);

		cq.select(from.get(Ticket_.flight).get(Flight_.plane).get(Plane_.modelPlane).get(ModelPlane_.colPassangersBuisnes));
		cq.where(cb.equal(from.get(Ticket_.id), 1));  
		return em.createQuery(cq).getFirstResult();
		
	}