Zend FR

SELECT *
FROM `jeux` AS `j`
LEFT JOIN `favoris_jeux` AS `f` ON f.id_jeux = j.id_jeux
AND f.email_compte = 'XXXXXXX'
ORDER BY `f`.`email_compte` DESC

$jeux = new Jeux();
$select = $jeux->select()->setIntegrityCheck(false);

$select->from("jeux")
         ->joinLeft(array("f" => "favoris_jeux"), "f.id_jeux = j.id_jeux ", array() )
     ->where("f.email_compte = ?", $option["email_compte"])  //Mais where n'est pas approprié dans ce cas
     ->order("f.email_compte DESC");