SELECT a.*,b.title,b.template,b.description,b.tags FROM projet a LEFT JOIN projet_lang b on (b.langue_id='fr'AND b.projet_id = a.id)WHERE b._slug='fr'