'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 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.idType<> :blockedType LIMIT 1' Contraste - NWA3R-EM (Emergency Driver) -