Zend FR

 $select->from(array('pers'=>'personne'), 
                        array( 'pers_avatar',
                               'pers_nom',
                               'pers_nbvideo',
                               'pers_id'));
         $select->join(array('pro'=>'profils'),'pers.pers_id = pro.profils_id','pro.profils_type');
         $select->join(array('techs'=>'techsports'),'pro.profils_sport = techs.sport_id','techs.sport_sport');
         $select->join(array('clu'=>'clubs'),'pro.profils_club = clu.club_id','clu.club_nomclub');
         $select->join(array('techd'=>'techdept'),'pro.profils_departement = techd.techdept_id','techd.techdept_numdep'); 
         $select->where(new Zend_Db_Expr('pers_nom LIKE "l%"'));
         $select->order(array('profils_communaute ASC',
                               'sport_pop ASC',
                               'profils_type DESC'));

 $paginator = Zend_Paginator::factory($select);
        $paginator->setCurrentPageNumber($this->_getParam('page',1));
        $paginator->setItemCountPerPage($this->_getParam('page',10));
        $this->view->pages = $paginator;