db->query("SELECT *, (SELECT v.code FROM oc_vendedores v WHERE v.code = u.vendedor_id) AS vendedor_id FROM oc_user u WHERE u.user_id = '" .(int)$this->getId(). "'"); return $query->row['vendedor_id']; }