public function fetch($id)
    {
        $table = new TableGateway('web_project', $this->adapter);

        $rowset = $table->select(function($select) use ($id) {
            $select->columns(array('projectname' => 'projectname', 'projectdescription' => 'description', 'projectcreationdate' => 'creationdate'));
            $select->join(
                array('t1' => 'web_prjcontext'),
                't1.fk_web_project = web_project.id',
                array('contextname' => 'name', 'contextdescription' => 'description'),
                Select::JOIN_LEFT
            );
            $select->join(
                array('t2' => 'web_prjright'),
                't2.fk_web_prjcontext = t1.id',
                array('rightname' => 'name', 'rightmatrix' => 'matrix', 'rightdescription' => 'description'),
                Select::JOIN_LEFT
            );
            $select->where(array('projectname' => $id));
            $select->order(array('t1.name asc'));
            $select->order(array('t2.name asc'));
        });

        $dataEntity   = array();
        $dataEmbedded = array();

        foreach ($rowset as $row) {
            if (!isset($dataEntity['name'])) {
                $dataEntity['name']         = $this->cpcDbToClient->convert($row->projectname);
                $dataEntity['description']  = $this->cpcDbToClient->convert(stream_get_contents($row->projectdescription));
                $dataEntity['creationDate'] = $row->projectcreationdate;
            }

            if ($row->contextname) {
                $contextName = $this->cpcDbToClient->convert($row->contextname);

                if (!$dataEmbedded[$contextName]) {
                    $dataEmbedded[$contextName] = new RightscontextsEntity(
                        array(
                            'name'        => $contextName,
                            'description' => $this->cpcDbToClient->convert($row->contextdescription),
                        )
                    );
                }