'Select b.*, t.nom as type, p.nom as produitNom from boitier b inner join type t on b.idType=t.idType inner join boitier_trim bt on b.idBoitier=bt.idBoitier inner join trim tr on bt.idTrim=tr.idTrim and tr.idStatus<>:STATUS_INACTIVE1 inner join produit p on p.idProduit=tr.idProduit inner join entry e on b.nom=e.idTranslation where lower(e.text)=lower(:nomBoitier) and b.idStatus<> :STATUS_INACTIVE2 LIMIT 1' Contraste - ECO2NWL200-277 (277V) -