Zend FR

<?php
// Connection Component Binding
Doctrine_Manager::getInstance()->bindComponent('Model_Evenement', 'doctrine');

/**
 * Model_Base_Evenement
 * 
 * This class has been auto-generated by the Doctrine ORM Framework
 * 
 * @property integer $id_evenement
 * @property integer $id_sport
 * @property string $titre
 * @property string $description
 * @property string $adresse
 * @property string $ville 
 * @property Model_Sport $Sport

abstract class Model_Base_Evenement extends Doctrine_Record
{
    public function setTableDefinition()
    {
        $this->setTableName('evenement');
        $this->hasColumn('id_evenement', 'integer', 4, array(
             'type' => 'integer',
             'length' => 4,
             'fixed' => false,
             'unsigned' => false,
             'primary' => true,
             'autoincrement' => false,
             ));

        $this->hasColumn('id_sport', 'integer', 4, array(
             'type' => 'integer',
             'length' => 4,
             'fixed' => false,
             'unsigned' => false,
             'primary' => false,
             'notnull' => true,
             'autoincrement' => false,
             ));
....

}
 public function setUp()
    {
        parent::setUp();       

        $this->hasOne('Model_Sport as Sport', array(
             'local' => 'id_sport',
             'foreign' => 'id_sport'));
}


}

public function ListEvts()
     {
         $qr = Doctrine_Query::create()
                ->select('*')
                ->from('Model_Evenement e')
                ->leftJoin('e.Model_Sport s')
                ->orderBy('e.id_evenement DESC');         
        
        return $qr->execute();
}