function findLastAlbum() { $t = new Activites(); $db = $t->getAdapter(); $s = $this->select()->setIntegrityCheck(false)->distinct()->from('activite')->join('participation', 'participation.activite = activite.id', array())->joinLeft(array('fille' => 'unite'), $db->quoteInto('fille.parent = ?', $this->id), array())->joinLeft(array('petitefille' => 'unite'), 'petitefille.parent = fille.id', array())->join('photo', 'photo.activite = activite.id', array())->where('participation.unite IN (?, fille.id, petitefille.id)', $this->id)->order('fin DESC'); return $t->fetchFirst($s); }